Questions tagged [dask-to-sql]

3 questions
7
votes
3 answers

Using Dask's NEW to_sql for improved efficiency (memory/speed) or alternative to get data from dask dataframe into SQL Server Table

My ultimate goal is to use SQL/Python together for a project with too much data for pandas to handle (at least on my machine). So, I have gone with dask to: read in data from multiple sources (mostly SQL Server Tables/Views) manipulate/merge the…
David Erickson
  • 16,433
  • 2
  • 19
  • 35
0
votes
0 answers

Server Disconnected Error: python with postgresql

I'm trying to upload some heavy data in postgresql from dask python but it's giving the following error: Server Disconnected. Can anyone help me? code: base_SP.to_sql('SIPNI_SP2',…
0
votes
1 answer

Expected URI to be a string to_sql()

I am trying to upload a large dask dataframe to a sql server but i'm getting an error and can't see anything wrong with the connection string. I am able to connect to the DB using this connection string but I get the error when running the…
Sql_Pete_Belfast
  • 570
  • 4
  • 23