How to truncate a snowflake table before loading it from AWS Glue

Question

We are having some AWS Glue jobs , which are reading the data from Amazon S3 Locations and writing data into snowflake tables. We want to truncate the tables before each load. could someone helping me to do this.

Thanks, Ram.

question from:https://stackoverflow.com/questions/65937187/how-to-truncate-a-snowflake-table-before-loading-it-from-aws-glue

Answer 1

Simply run truncate query

truncate table if exists table_name;

If what you are asking is how to create an ETL that incorporate the AWS Glue job with running query on Snowflake that is depended on the ETL tool that you use and what it can do. That however is a question for the ETL tool that you are using. i can suggest using Apache Airflow which can schedule Glue jobs and run Snowflake queries.