Exploratory Sprint: Snowflake Data Warehouse Support
We should check our support for loading data to Snowflake: We have a fully working Snowflake loader which we have built internally, used with production data and thoroughly tested by itself, but we have to evaluate our end to end support of Snowflake in the post V1 Meltano implementation.
Tasks:
-
Evaluate the Extract - Load pipeline --> (@iroussos) Result: Success -
Check that target-snowflake
works with all our supported Taps --> pending after other steps are done -
Check if our current dbt transforms work with Snowflake --> (@iroussos) Result: Fail -
Check if Meltano UI and Meltano Analyze work with Snowflake --> (@iroussos) Result: Fail -
@dmor write a full Opportunity Assessment
2019-11-10: Based on re-calibration of persona, this needs to be deprecated
-
@dmor complete opportunity assessment to document and connect to persona -
@dmor create deprecation checklist to sunset this functionality in the product and the marketing website
Work Items
- Go through each extractor and make sure it works
- Fix any broken transforms
- Figure out what is wrong is with Snowflake + Meltano Analyze
Edited by Danielle Morrill