We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Please describe the feature you'd like to see Currently while creating stage, the Loadfile implementation for snowflake only takes integration storage details from native_support_kwargs . This is how COPY INTO command isbeing used: https://github.com/astronomer/astro-sdk/blob/main/python-sdk/src/astro/databases/snowflake.py#L608
It should support all format options for all file types.
Describe the solution you'd like
User should be able to run something like the following using load file
copy into flight_data from 's3://jf-ml-data/flight_data/On_Time_Reporting_Carrier_On_Time_Performance_1987_present_2022_3.csv' credentials=(aws_key_id='***' aws_secret_key='***') file_format = ( type = 'CSV' field_delimiter = ',' skip_header = 1 FIELD_OPTIONALLY_ENCLOSED_BY = '"' NULL_IF = ('NULL','null','') );
Slack thread: https://astronomer.slack.com/archives/C02B8SPT93K/p1672756338230149
Acceptance Criteria
The text was updated successfully, but these errors were encountered:
Successfully merging a pull request may close this issue.
Please describe the feature you'd like to see
Currently while creating stage, the Loadfile implementation for snowflake only takes integration storage details from native_support_kwargs . This is how COPY INTO command isbeing used: https://github.com/astronomer/astro-sdk/blob/main/python-sdk/src/astro/databases/snowflake.py#L608
It should support all format options for all file types.
Describe the solution you'd like
User should be able to run something like the following using load file
Slack thread: https://astronomer.slack.com/archives/C02B8SPT93K/p1672756338230149
Acceptance Criteria
The text was updated successfully, but these errors were encountered: