Data Engineering, Elt Pipeline, Apache Airflow, Kinesis Firehose, Snowflake Data Cloud.
'{IAM role arn}' ENABLED = TRUE STORAGE_ALLOWED_LOCATIONS = ('s3://{bucket_name}/firehose/'); We need to get AWS external ID and AWS user arn to put into the Trust Relationship of the IAM role. To get those, we will run DESC INTEGRATION YOUR_INTEGRATION_NAME; So the storage integration is ready.