Summary
User inquires about the ability to split JSON data into multiple columns during the loading process from LinkedIn Ads into the database.
Question
Hi is it possible can we split this data into multiple columns while loading “{”amount”: “0.35”, “currencyCode”: “EUR”}” i see data like this in my data base after i download from linkedinAds
can we have some getting to split while downloading
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
['split-data', 'multiple-columns', 'linkedin-ads', 'json']
Once we migrate LinkedIn ads all the way to manifest only format, you’d be able to fork it in Connector Builder and add a field transformation to add two custom fields for currency and amount.
Before that, we’ll also soon introduce basic transformations in the platform.
And before that, you can do it downstream with dbt.
Once we migrate LinkedIn ads all the way to manifest only format, you’d be able to fork it in Connector Builder and add a field transformation to add two custom fields for currency and amount.
Before that, we’ll also soon introduce basic transformations in the platform.
And before that, you can do it downstream with dbt.