Afroz Alam comments

Results 17 comments of


                                            Afroz Alam

SNOW-616199: updated _resolve_packages to only query for added packages

I have read the CLA Document and I hereby sign the CLA

SNOW-1306306: `DataFrame.cache_result()` type hinting

@shanefrieskh would you mind creating a PR for this? Keep in mind the circular import between dataframe.py and table.py https://adamj.eu/tech/2021/05/13/python-type-hints-how-to-fix-circular-imports/

SNOW-796954: get_table_names fails with over 10,000 tables.

Hey @travischambers, would you be interested in creating a PR with your suggestions?

SNOW-872017: Add wrapper function to encapsulate the result from write_pandas into a dataclass

This is a good suggestion and we will work on it in the future. If you are willing to help, please create a PR and we would review and merge...

Fix Code generation and Types to be compatible with Python 3.11+

@sfc-gh-aling can you review this one please

SNOW-994645: snowflake.connector.errors.ProgrammingError: 001003 (42000): SQL compilation error: syntax error line 1 at position 27 unexpected 'ON'

@jm-nab you are trying to create index in snowflake which is not supported. Do you know where create index statement is generated from?

SNOW-886649: write_pandas inserts datetime64[ns] to Snowflake as an Invalid Date

closing this issue as `use_logical_type` is working as expected. Please open a new issue if you see more issues.

SNOW-886649: write_pandas inserts datetime64[ns] to Snowflake as an Invalid Date

It is coming in the next release.

SNOW-886649: write_pandas inserts datetime64[ns] to Snowflake as an Invalid Date

My bad. I thought this was snowflake-connector-python issue

SNOW-620952: After upgrading to version 2.7.9, empty Snowflake table is being created when using pandas to_sql(method=pd_writer)

Looking at pandas code gives me some more hint towards the problem. See: https://github.com/pandas-dev/pandas/blob/v1.5.1/pandas/io/sql.py#L1396-L1399 Based on this, either @budaesandrei's solution works, or if you would like to use `engine.connect() as...