I am getting error with snowflake access
customers_model:
+post-hook:
-
COPY INTO 's3://sravyapractice1/output/'
FROM (SELECT * FROM {{ this }})
FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = ',' RECORD_DELIMITER = '\n' SKIP_HEADER = 0)
SINGLE = TRUE;
Some example code or error messages
20:43:56 Began running node model.insurance_project.customers_model
20:43:56 3 of 10 START sql table model dbt_sravyats94_dbt_sravyats94.customers_model .... [RUN]
20:43:56 Acquiring new snowflake connection 'model.insurance_project.customers_model'
20:43:56 Began compiling node model.insurance_project.customers_model
20:43:56 Writing injected SQL for node "model.insurance_project.customers_model"
20:43:56 Began executing node model.insurance_project.customers_model
20:43:56 Writing runtime sql for node "model.insurance_project.customers_model"
20:43:56 Using snowflake connection "model.insurance_project.customers_model"
20:43:56 On model.insurance_project.customers_model: /* {"app": "dbt", "dbt_version": "2024.9.239", "profile_name": "user", "target_name": "default", "node_id": "model.insurance_project.customers_model"} */
create or replace transient table Analytics.dbt_sravyats94_dbt_sravyats94.customers_model
as
(-- models/customers_model.sql
SELECT
Cust_Id,
Cust_FName,
Cust_LName,
Cust_DOB,
Cust_Gender,
Cust_Address,
Cust_MOB_Number,
Cust_Email,
Cust_Passport_Number,
Cust_Marital_Status
FROM Analytics.dbt_sravyats94.customers -- Reference the seed 'customers'
);
20:43:56 Opening a new connection, currently in state init
20:43:57 SQL status: SUCCESS 1 in 0.605 seconds
20:43:57 Using snowflake connection "model.insurance_project.customers_model"
20:43:57 On model.insurance_project.customers_model: /* {"app": "dbt", "dbt_version": "2024.9.239", "profile_name": "user", "target_name": "default", "node_id": "model.insurance_project.customers_model"} */
COPY INTO 's3://sravyapractice1/output/'
FROM (SELECT * FROM Analytics.dbt_sravyats94_dbt_sravyats94.customers_model)
FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = ',' RECORD_DELIMITER = '
' SKIP_HEADER = 0)
SINGLE = TRUE;
20:43:57 Snowflake adapter: Snowflake query id: 01b6fd1b-0000-b15c-0001-1eb200032176
20:43:57 Snowflake adapter: Snowflake error: 100089 (42501): 01b6fd1b-0000-b15c-0001-1eb200032176: Failed to access remote file: access denied. Please check your credentials
20:43:57 Database Error in model customers_model (models/customers_model.sql)
100089 (42501): 01b6fd1b-0000-b15c-0001-1eb200032176: Failed to access remote file: access denied. Please check your credentials
compiled Code at target/run/insurance_project/models/customers_model.sql
20:43:57 3 of 10 ERROR creating sql table model dbt_sravyats94_dbt_sravyats94.customers_model [e[31mERRORe[0m in 1.41s]
20:43:57 Finished running node model.insurance_project.customers_model
20:43:58 Database Error in model customers_model (models/customers_model.sql)
100089 (42501): 01b6fd1b-0000-b15c-0001-1eb200032176: Failed to access remote file: access denied. Please check your credentials
compiled Code at target/run/insurance_project/models/customers_model.sql