python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - pandas-to-sql

Make pandas.to_sql to create tables with lowercase table name in SAP HANA database

Simple, i just want to create lowercase tables with pandas.to_sql. Tried the following: df.to_sql(name=hdb_table_name.lower(), schema="SCHEMA_NAME", con=hdb_connection, index=True, if_exists...
test-img

sony

python

pandas

sqlalchemy

hana

pandas-to-sql

Votes: 0

Answers: 2

Latest Answer

This might be helpful: in SAP Hana At the time of table creation, the case of a column name is not preserved unless the column name is quoted. Snowflake stores unquoted column names in uppercase. Th...
test-img

eshirvana

How do I proper upload a huge pandas dataframe into a postgres sql database?

I am trying to upload a very big pandas df (13230 rows x 2502 cols) into a postgres database. I am uploading the dataframe with the function df_to_sql but it gives me this error: tables can have at mo...
test-img

arrabattapp man

sql

pandas

postgresql

dataframe

pandas-to-sql

Votes: 0

Answers: 0

SQL Server sys.tables not capturing correct modify_date

Context: I have an ETL process setup to populate tables in a datawarehouse using a Python script. The script executes a truncate statement via sqlalchemy to empty each of the tables then uses the pand...
test-img

emalcolmb

sql-server

pandas

sqlalchemy

truncate

pandas-to-sql

Votes: 0

Answers: 1

Latest Answer

modify_date doesn't capture TRUNCATE (or any changes to the data). From the documentation on sys.objects (which is where sys.tables gets its columns): Date the object was last modified by using an AL...
test-img

Aaron Bertrand

Posts

Questions

Blogs

Jobs