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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive