Nov. 29, 2023, 7:30 p.m. | /u/tyw214

Data Science www.reddit.com

hey guys, so I am doing ETL for our databases in netsuite/salesforce/many other disparate db through DBT into Snowflake for data warehouse.

NS/SF themselves doesn't seem to have any convention/logical way of how they order columns. When you do select \* from \[table\] from these db, how the data is presented doesn't seem to be organized in any particular way.

but as i am transforming these data into the data warehouse, do you guys re-order these columns?

I am torn …

column convention data databases datascience data warehouse dbt etl hey practice salesforce snowflake standard table through warehouse

Founding AI Engineer, Agents

@ Occam AI | New York

AI Engineer Intern, Agents

@ Occam AI | US

AI Research Scientist

@ Vara | Berlin, Germany and Remote

Data Architect

@ University of Texas at Austin | Austin, TX

Data ETL Engineer

@ University of Texas at Austin | Austin, TX

Machine Learning Engineer

@ Apple | Sunnyvale, California, United States