data extraction to an external account (big query)

[rbiri]

Hello

We need to extract the data from a list to a big query external account already set up, we are able to receive data from Big Query, but  when I set up my file  upload acitvity, in theremote server part, my external account  is not availble to select.

The big query external account we set up, is an external database type

Any ideas?

PS: we dont want to transfer to SFTP

[somasundaram_h]

Hi, I guess you're loading data using Data loading(RDBMS) activity. And you wish to use the same activity to send data to external database. If that is the case, it is not possible. Let me know what activities you used to import data and what activities you tried for exporting?

[razengaan]

Hi

Yes, we set up an external account (external database type) to pick up file from Big Query, and we use a data loading RDBMS to check that data source in a specific table name, and we select a column to extract.

But we want now, transfer files to Big Query through the same external account.

..If there is no other way, we will try the regular approach (file to sftp)..

[somasundaram_h]

Hi, data loading RDBMS activity - this is self explanatory. We can only load data using that activity and not possible to push data using that. However, we may try different approach if you're familiar with Javascript and SQL. But this requires deep understanding of External accounts setup, Javascript, SQL and looping all your data inside JS.

Example: 

sqlExecOnDataSource("UPDATE XtkOption SET sStringValue = $(sz) WHERE sName = $(sz)", oracleExternalDB, 'WdbcOptions_TableSpaceWork_nms:extAccount:' + ExtAccount)

Reference: https://experienceleague.adobe.com/developer/campaign-api/api/f-sqlExecOnDataSource.html

The user friendly approach will be via File transfer activity. Hope this helps.

[razengaan]

ok thank you!