Two teams each have a schema named sales and a table named orders. How should a query unambiguously identify the intended table?

Published
  1. Put the workspace display name in the WHERE clause
  2. Use its catalog.schema.table name
  3. Use only orders and rely on a descriptive comment
  4. Rename every column to include the team name

Comments — 0