How to use upload-snowflake domo-cli command

When i tried the upload-snowflake as
upload-snowflake -j 'snowflake-jdbc-3.13.14.jar' --jdbcUrl 'jdbc:snowflake://pidfsdf76.ap-south-1.aws.snowflakecomputing.com/?warehouse=POC_WH&db=POC&schema=LANDING' -db 'POC' -schema 'LANDING' -t 'TABLE_NAME' -w 'POC_WH' --jdbcUser pocuser --jdbcPassword 'pass' -i 'cdff7a82-9440-4c7f-9bc4-3c40787ef878' -arn 'arn:aws:s3:::abc-buck-1' -b 'abc-buck-1' -f 'domo_cli_1' -k 'AKIAV2BKJDCHD54LPK' -s 'hdjuegcFMgzXulvrg1sQPZdu2kKDRFhbBHyCjh/s' -r 'Asia Pacific (Mumbai) ap-south-1'
I am getting error as
copy into s3://abc-buck-1/domo_cli_1/null from TABLE_NAME credentials = (AWS_KEY_ID = 'AKIAV2BKJDCHD54LPK' AWS_SECRET_KEY = 'hdjuegcFMgzXulvrg1sQPZdu2kKDRFhbBHyCjh/s') file_format = (type=csv compression='gzip' field_optionally_enclosed_by='"') single=false max_file_size=100_000_000 overwrite=true
ERROR in getDataStreams(): SQL compilation error:
syntax error line 1 at position 282 unexpected 'overwrite'.
net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
syntax error line 1 at position 282 unexpected 'overwrite'.
Answers
-
Hi @Raj
This is something the Labs team would need to investigate as it appears to be a bug in the CLI. Since they'll have access to the source code I'd recommend opening up a ticket with support to help your issue get resolved.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 824 Beast Mode
- Visualize
- 2.6K Charting
- 87 App Studio
- 46 Variables
- Automate
- 195 Apps
- 486 APIs & Domo Developer
- 90 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive