how to make flat schema

Question

Is it possible to make flat Schema? I would like to move the data from that dataset into Accelerated Store and that's why I am asking about flat schemas:

Ankit_Chaudhary · Accepted Answer

Hi @michael_soprano You have to custom define all the fields which you can attach to a schema but it will still appear under your tenant ID to avoid conflict with other standard fields.

arijitg · Answer

Hi @michael_soprano

I'm not very sure what your end goals are but when you use accelerated store you can create your database, schema, table directly from query panel and that can be of a flat structure. Below is a sample code snippet if it helps -->

/*

CREATE database my_database_name WITH (TYPE=QSACCEL, ACCOUNT=acp_query_batch);

CREATE schema my_database_name.my_model_name;

CREATE TABLE IF NOT exists my_database_name.my_model_name.my_table_name WITH ( DISTRIBUTION = REPLICATE ) AS

SELECT cast(null as int) buy_price,

cast(null as string) buy_product,

cast(null as string) buy_location,

cast(null as timestamp) buy_date

WHERE false;

*/

Ref : Query Accelerated Store Reporting Insights Guide | Adobe Experience Platform

Regards,

Arijit Ghosh

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded