Connector Improvement: "Google Analytics 4 Export" Connector -Datalake Destination (Athena External Table))
PlannedCurrently "Google Analytics 4 Export" connector for datalake destination writes the data as Iceberg tables.
It will be good, if Fivetran provides option to write it as a regular “Athena External table”? (i.e write daily data into s3 bucket in "s3://<bucket_name>/<some-path>/yyyy-mm-dd/" folder pattern ). So that we can use External table to expose to Redshift Spectrum
-
Official comment
Hi Nasrudeen,
Thank you for raising this request. Support for Redshift Spectrum is on the short term roadmap. We are working in partnership with AWS to enable Spectrum support for S3 + Iceberg.
Regards,
Meera
-
Hi Nasrudeen,
Great news! Our AWS S3 destination is in GA and we have successfully tested querying Iceberg data with Redshift Spectrum.
Best,
Coral
Please sign in to leave a comment.
Comments
2 comments