Is there any way to get Meltano to extract data out of a col Meltano #announcements

Is there any way to get Meltano to extract data ou...

al_whatmough

12/11/2019, 12:59 AM

Is there any way to get Meltano to extract data out of a column containing JSON data (when storing the data in Postgtres using target-postgres)?

micael_bergeron

12/11/2019, 1:23 PM

What is the data source?

micael_bergeron

12/11/2019, 1:23 PM

What extractor are you using?

micael_bergeron

12/11/2019, 1:23 PM

Typically you would do that part of a transform, unless you want to remove the whole column

al_whatmough

12/11/2019, 10:19 PM

The data source is Survey Monkey (been working on this for a while now) so I had to install it as a custom extractor

al_whatmough

12/11/2019, 10:20 PM

Thanks for the tip - I think I can do this in the transform stage using dbt (and Postgres' JSON handling functions)

5 Views