How to use upload-snowflake domo-cli command
![Raj](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 769 Beast Mode
- 72 App Studio
- 43 Variables
- 718 Automate
- 185 Apps
- 462 APIs & Domo Developer
- 57 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive