Looking on opinions, critique, and also some help on this practice. I am moving sources into big query. I want all sources to end up in it's own schema.
⢠When using big query as a destination I can't seem to override the default schema. I have to edit the default schema before each sync manually. Am I missing the place within the sources to do this?
⢠What are people's opinion on a schema per source and then creating additional schemas for the transformed/business friendly data. I assume this practice is fine as long as it works for the business?
These may be amateur questions but my background isn't old school BI engineer and actually come more from a data analyst/scientist background. For my current role for now it seems I will be doing the whole end to end from the engineering to the 'actionable insights' (or whatever buzz term you want to use)