ืกืงื™ืจื” ื›ืœืœื™ืช ืขืœ Dataform

ื‘ืžืกืžืš ื”ื–ื” ืžื•ืกื‘ืจื™ื ื”ืžื•ืฉื’ื™ื ื•ื”ืชื”ืœื™ื›ื™ื ืฉืœ Dataform.

โ€ซDataform ื”ื•ื ืฉื™ืจื•ืช ืฉืžืืคืฉืจ ืœื ืชื— ื ืชื•ื ื™ื ืœืคืชื—, ืœื‘ื“ื•ืง, ืœืฉืœื•ื˜ ื‘ื’ืจืกืื•ืช ื•ืœืชื–ืžืŸ ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ืžื•ืจื›ื‘ื™ื ืœืฉื™ื ื•ื™ ื ืชื•ื ื™ื ื‘-BigQuery.

ื‘ืขื–ืจืช Dataform ืืชื ื™ื›ื•ืœื™ื ืœื ื”ืœ ืืช ื”ื˜ืจื ืกืคื•ืจืžืฆื™ื” ืฉืœ ื”ื ืชื•ื ื™ื ื‘ืชื”ืœื™ืš ื”ื—ื™ืœื•ืฅ, ื”ื˜ืขื™ื ื” ื•ื”ื˜ืจื ืกืคื•ืจืžืฆื™ื” (ELT) ืœืฉื™ืœื•ื‘ ื ืชื•ื ื™ื. ืื—ืจื™ ืฉืฉื•ืœืคื™ื ืืช ื”ื ืชื•ื ื™ื ื”ื’ื•ืœืžื™ื™ื ืžืžืขืจื›ื•ืช ื”ืžืงื•ืจ ื•ื˜ื•ืขื ื™ื ืื•ืชื ืœ-BigQuery, ืืคืฉืจ ืœื”ืฉืชืžืฉ ื‘-Dataform ื›ื“ื™ ืœื”ืžื™ืจ ืื•ืชื ืœื—ื‘ื™ืœื” ืžื•ื’ื“ืจืช ื”ื™ื˜ื‘, ืžืชื•ืขื“ืช ื•ื ื‘ื“ืงืช ืฉืœ ื˜ื‘ืœืื•ืช ื ืชื•ื ื™ื.

โ€ซDataform ืžืืคืฉืจ ืœื‘ืฆืข ืืช ืคืขื•ืœื•ืช ื”ืฉื™ื ื•ื™ ื”ื‘ืื•ืช ื‘ื ืชื•ื ื™ื:

  • ืคื™ืชื•ื— ื•ื”ืจืฆื” ืฉืœ ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ืœื˜ืจื ืกืคื•ืจืžืฆื™ื” ืฉืœ ื ืชื•ื ื™ื.
  • ืฉื™ืชื•ืฃ ืคืขื•ืœื” ืขื ื—ื‘ืจื™ ื”ืฆื•ื•ืช ื‘ืคื™ืชื•ื— ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ื‘ืืžืฆืขื•ืช Git.
  • ืœื ื”ืœ ืžืกืคืจ ื’ื“ื•ืœ ืฉืœ ื˜ื‘ืœืื•ืช ื•ืืช ื™ื—ืกื™ ื”ืชืœื•ืช ืฉืœื”ืŸ.
  • ื”ืฆื”ืจื” ืขืœ ื ืชื•ื ื™ ื”ืžืงื•ืจ ื•ื ื™ื”ื•ืœ ื™ื—ืกื™ ื”ืชืœื•ืช ืฉืœ ื”ื˜ื‘ืœื”.
  • ื”ืฆื’ืช ื”ืžื—ืฉื” ื•ื™ื–ื•ืืœื™ืช ืฉืœ ืขืฅ ื”ืชืœื•ืช ืฉืœ ื–ืจื™ืžืช ื”ืขื‘ื•ื“ื”.
  • ื ื™ื”ื•ืœ ื ืชื•ื ื™ื ื‘ืืžืฆืขื•ืช ืงื•ื“ SQL ื‘ืžืื’ืจ ืžืจื›ื–ื™.
  • ืฉื™ืžื•ืฉ ื—ื•ื–ืจ ื‘ืงื•ื“ ื‘ืืžืฆืขื•ืช JavaScript.
  • ื‘ื•ื“ืงื™ื ืืช ื ื›ื•ื ื•ืช ื”ื ืชื•ื ื™ื ื‘ืืžืฆืขื•ืช ื‘ื“ื™ืงื•ืช ืื™ื›ื•ืช ื‘ื˜ื‘ืœืื•ืช ื”ืžืงื•ืจ ื•ื”ืคืœื˜.
  • ื ื™ื”ื•ืœ ื’ืจืกืื•ืช ืฉืœ ืงื•ื“ SQL.
  • ืœืชืขื“ ื˜ื‘ืœืื•ืช ื ืชื•ื ื™ื ืฉืœ ืžืกืžื›ื™ื ื‘ืชื•ืš ืงื•ื“ SQL.

ืชื”ืœื™ื›ื™ ื˜ืจื ืกืคื•ืจืžืฆื™ื” ืฉืœ ื ืชื•ื ื™ื ื‘-Dataform

ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ืฉืœ ื”ืžืจืช ื ืชื•ื ื™ื ื‘-Dataform ื”ื•ื ื›ื–ื”:

  1. ื‘-Dataform ืืชื ื™ื›ื•ืœื™ื ืœื™ืฆื•ืจ ืžืื’ืจื™ื ื›ื“ื™ ืœื ื”ืœ ืืช ื”ืงื•ื“ ืฉืœื›ื.
  2. ื‘-Dataform ืืคืฉืจ ืœื™ืฆื•ืจ ืกื‘ื™ื‘ื•ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—.
  3. ื‘-Dataform ืืคืฉืจ ืœืคืชื— ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—.
  4. โ€ซDataform ืžื”ื“ืจ ืืช Dataform Core ืœ-SQL.
  5. โ€ซDataform ืžืจื™ืฅ ืืช ืขืฅ ื”ืชืœื•ืช.

โ€ซDataform ืžืืคืฉืจ ืœื™ืฆื•ืจ ืžืื’ืจื™ื ืœื ื™ื”ื•ืœ ื”ืงื•ื“

ื‘ืžืื’ืจ ืฉืœ Dataform, ืžืฉืชืžืฉื™ื ื‘-Dataform core, ืชื•ืกืฃ ืฉืœ SQL, ื›ื“ื™ ืœื›ืชื•ื‘ ืงื•ื‘ืฆื™ SQLX ืฉื‘ื”ื ืžื’ื“ื™ืจื™ื ืืช ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื”. ืžืื’ืจื™ Dataform ืชื•ืžื›ื™ื ื‘ื ื™ื”ื•ืœ ื’ืจืกืื•ืช. ืืชื ื™ื›ื•ืœื™ื ืœืงืฉืจ ืžืื’ืจ ืฉืœ Dataform ืœืกืคืง Git ืฉืœ ืฆื“ ืฉืœื™ืฉื™.

ื‘-Dataform ืืคืฉืจ ืœื™ืฆื•ืจ ืกื‘ื™ื‘ื•ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—

ืืชื ื™ื›ื•ืœื™ื ืœื™ืฆื•ืจ ืกื‘ื™ื‘ื•ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื— ื‘ืชื•ืš ืžืื’ืจ Dataform ืœืคื™ืชื•ื— ืœื™ื‘ื” ืฉืœ Dataform. ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—, ืืชื ื™ื›ื•ืœื™ื ืœื‘ืฆืข ืฉื™ื ื•ื™ื™ื ื‘ืžืื’ืจ, ืœืงืžืคืœ, ืœื‘ื“ื•ืง ื•ืœื“ื—ื•ืฃ ืื•ืชื ืœืžืื’ืจ ื”ืจืืฉื™ ื‘ืืžืฆืขื•ืช Git.

ื‘-Dataform ืืชื ื™ื›ื•ืœื™ื ืœืคืชื— ืืช Dataform Core ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—

ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—, ืืชื ื™ื›ื•ืœื™ื ืœื”ื’ื“ื™ืจ ื•ืœืชืขื“ ื˜ื‘ืœืื•ืช, ืืช ื”ืชืœื•ืช ืฉืœื”ืŸ ื•ืืช ืœื•ื’ื™ืงืช ื”ืฉื™ื ื•ื™ ื›ื“ื™ ืœื‘ื ื•ืช ืืช ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื”. ืืคืฉืจ ื’ื ืœื”ื’ื“ื™ืจ ืคืขื•ืœื•ืช ื‘-JavaScript.

โ€ซDataform ืžื‘ืฆืข ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ Dataform Core

ื‘ืžื”ืœืš ื”ื”ื™ื“ื•ืจ, ืžืชื‘ืฆืขื•ืช ื‘-Dataform ื”ืžืฉื™ืžื•ืช ื”ื‘ืื•ืช:

  • ื”ื™ื“ื•ืจ ืฉืœ Dataform core ืœืชื”ืœื™ืš ืขื‘ื•ื“ื” ืฉืœ SQL ืกื˜ื ื“ืจื˜ื™.
  • ื”ื•ืกืคืช ื”ืฆื”ืจื•ืช SQL ืกื˜ื ื“ืจื˜ื™ื•ืช, ื›ืžื• CREATE TABLE ืื• INSERT, ืœืงื•ื“ ื‘ืฉื•ืจื” ืขื ื”ื’ื“ืจืช ื”ืฉืื™ืœืชื”.
  • ื”ื›ืœื™ ืžื‘ืฆืข ื˜ืจื ืกืคื™ืœืฆื™ื” (ืงื•ืžืคื™ืœืฆื™ื” ืžืžืงื•ืจ ืœืžืงื•ืจ) ืฉืœ JavaScript ืœ-SQL.
  • ื”ื›ืœื™ ืคื•ืชืจ ืชืœื•ื™ื•ืช ื•ื‘ื•ื“ืง ืื ื™ืฉ ืฉื’ื™ืื•ืช, ื›ื•ืœืœ ืชืœื•ื™ื•ืช ื—ืกืจื•ืช ืื• ืžืขื’ืœื™ื•ืช.
  • ื™ื•ืฆืจ ืืช ืขืฅ ื”ืชืœื•ืช ืฉืœ ื›ืœ ื”ืคืขื•ืœื•ืช ืฉื™ื•ืคืขืœื• ื‘-BigQuery.

ื”ื”ื™ื“ื•ืจ ืฉืœ Dataform ื”ื•ื ื”ืจืžื˜ื™ ื›ื“ื™ ืœืืžืช ืืช ืขืงื‘ื™ื•ืช ื”ื”ื™ื“ื•ืจ, ื›ืœื•ืžืจ ืื•ืชื• ืงื•ื“ ืขื•ื‘ืจ ื”ื™ื“ื•ืจ ืœืื•ืชื” ืชื•ืฆืืช ื”ื™ื“ื•ืจ ืฉืœ SQL ื‘ื›ืœ ืคืขื. โ€ซDataform ืžืงืžืคืœ ืืช ื”ืงื•ื“ ื‘ืกื‘ื™ื‘ืช ืืจื’ื– ื—ื•ืœ ืœืœื ื’ื™ืฉื” ืœืื™ื ื˜ืจื ื˜. ื‘ืžื”ืœืš ื”ื”ื™ื“ื•ืจ ืœื ื–ืžื™ื ื•ืช ืคืขื•ืœื•ืช ื ื•ืกืคื•ืช, ื›ืžื• ืงืจื™ืื” ืœืžืžืฉืงื™ API ื—ื™ืฆื•ื ื™ื™ื.

ื›ื“ื™ ืœื ืคื•ืช ื‘ืื’ื™ื ื‘ื–ืžืŸ ืืžืช, ืืชื ื™ื›ื•ืœื™ื ืœื‘ื“ื•ืง ืืช ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื”ืžืงื•ืžืคืœ ืฉืœ ื”ืคืจื•ื™ืงื˜ ื‘ืชืจืฉื™ื ืื™ื ื˜ืจืืงื˜ื™ื‘ื™ ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—.

โ€ซDataform ืžืจื™ืฅ ืืช ืขืฅ ื”ืชืœื•ืช

ื‘-BigQuery, โ€Dataform ืžื‘ืฆืข ืืช ื”ืžืฉื™ืžื•ืช ื”ื‘ืื•ืช:

  • ืžืจื™ืฅ ืคืงื•ื“ื•ืช SQL ืœืคื™ ื”ืกื“ืจ ืฉืœ ืขืฅ ื”ืชืœื•ืช.
  • ืžืจื™ืฅ ืฉืื™ืœืชื•ืช ืฉืœ ื˜ืขื ื•ืช ืขืœ ื”ื˜ื‘ืœืื•ืช ื•ื”ืชืฆื•ื’ื•ืช ื›ื“ื™ ืœื‘ื“ื•ืง ืืช ื ื›ื•ื ื•ืช ื”ื ืชื•ื ื™ื.
  • ืžืจื™ืฆื” ืคืขื•ืœื•ืช SQL ืื—ืจื•ืช ืฉื”ื’ื“ืจืชื.
  • ืขื“ื›ื•ืŸ ื”ืžื˜ื-ื ืชื•ื ื™ื ื‘-Knowledge Catalog.

ืื—ืจื™ ื”ื”ืคืขืœื”, ืชื•ื›ืœื• ืœื”ืฉืชืžืฉ ื‘ื˜ื‘ืœืื•ืช ื•ื‘ืชืฆื•ื’ื•ืช ืœื›ืœ ืžื˜ืจื•ืช ื”ื ื™ืชื•ื— ืฉืœื›ื.

ืืชื ื™ื›ื•ืœื™ื ืœืฆืคื•ืช ื‘ื™ื•ืžื ื™ื ื›ื“ื™ ืœืจืื•ืช ืื™ืœื• ื˜ื‘ืœืื•ืช ื ื•ืฆืจื•, ืื ื˜ืขื ื•ืช ื”ื ื›ื•ึนื ื•ึผืช (assertions) ืขื‘ืจื• ืื• ื ื›ืฉืœื•, ื›ืžื” ื–ืžืŸ ื ืžืฉื›ื” ื›ืœ ืคืขื•ืœื” ื•ืžื™ื“ืข ื ื•ืกืฃ. ืืคืฉืจ ื’ื ืœืจืื•ืช ืืช ืงื•ื“ ื”-SQL ื”ืžื“ื•ื™ืง ืฉื”ื•ืคืขืœ ื‘-BigQuery.

ื”ืชื›ื•ื ื•ืช ืฉืœ Dataform

ื‘ืขื–ืจืช Dataform, ืืคืฉืจ ืœืคืชื— ื•ืœืคืจื•ืก ื˜ื‘ืœืื•ืช, ื˜ื‘ืœืื•ืช ืžืฆื˜ื‘ืจื•ืช ืื• ืชืฆื•ื’ื•ืช ื‘-BigQuery. ื‘-Dataform ื™ืฉ ืกื‘ื™ื‘ืช ืื™ื ื˜ืจื ื˜ ืœืคืขื™ืœื•ื™ื•ืช ื”ื‘ืื•ืช:

  • ืคื™ืชื•ื— ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื”
  • ื—ื™ื‘ื•ืจ ืœ-GitHub,โ€ GitLab,โ€ Azure DevOps Services ื•-Bitbucket
  • ืื™ื ื˜ื’ืจืฆื™ื” ืจืฆื™ืคื” (CI) ื•ืคืจื™ืกื” ืจืฆื™ืคื” (CD)
  • ื‘ื™ืฆื•ืข ืฉืœ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื”

ื‘ืงื˜ืขื™ื ื”ื‘ืื™ื ืžืคื•ืจื˜ื™ื ื”ืžืืคื™ื™ื ื™ื ื”ืขื™ืงืจื™ื™ื ืฉืœ Dataform.

ืžืื’ืจื™ื

ื›ืœ ืคืจื•ื™ืงื˜ ื‘-Dataform ืžืื•ื—ืกืŸ ื‘ืžืื’ืจ. ืžืื’ืจ Dataform ืžื›ื™ืœ ืื•ืกืฃ ืฉืœ ืงื•ื‘ืฆื™ ืชืฆื•ืจื” ื‘ืคื•ืจืžื˜ JSON, ืงื•ื‘ืฆื™ SQLX ื•ืงื•ื‘ืฆื™ JavaScript.

ืžืื’ืจื™ Dataform ืžื›ื™ืœื™ื ืืช ืกื•ื’ื™ ื”ืงื‘ืฆื™ื ื”ื‘ืื™ื:

  • ืงื•ื‘ืฆื™ ืชืฆื•ืจื”

    ืงื•ื‘ืฆื™ JSON ืื• SQLX ืžืืคืฉืจื™ื ืœื”ื’ื“ื™ืจ ืืช ืชื”ืœื™ื›ื™ ื”ืขื‘ื•ื“ื”. ื”ื ืžื›ื™ืœื™ื ื”ื’ื“ืจื•ืช ื›ืœืœื™ื•ืช, ืœื•ื—ื•ืช ื–ืžื ื™ื ืœื”ืจืฆื” ืื• ืกื›ื™ืžื” ืœื™ืฆื™ืจืช ื˜ื‘ืœืื•ืช ื•ืชืฆื•ื’ื•ืช ื—ื“ืฉื•ืช.

  • ื”ื’ื“ืจื•ืช

    ื”ื’ื“ืจื•ืช ื”ืŸ ืงื•ื‘ืฆื™ SQLX ื•-JavaScript ืฉืžื’ื“ื™ืจื™ื ื˜ื‘ืœืื•ืช ื—ื“ืฉื•ืช, ืชืฆื•ื’ื•ืช ื•ืคืขื•ืœื•ืช SQL ื ื•ืกืคื•ืช ืœื”ืจืฆื” ื‘-BigQuery.

  • ื›ื•ืœืœ

    Includes ื”ื ืงื•ื‘ืฆื™ JavaScript ืฉื‘ื”ื ืืชื ื™ื›ื•ืœื™ื ืœื”ื’ื“ื™ืจ ืžืฉืชื ื™ื ื•ืคื•ื ืงืฆื™ื•ืช ืœืฉื™ืžื•ืฉ ื‘ืคืจื•ื™ืงื˜.

ื›ืœ ืžืื’ืจ Dataform ืฆืจื™ืš ืœื”ื™ื•ืช ืžืงื•ืฉืจ ืœื—ืฉื‘ื•ืŸ ืฉื™ืจื•ืช ืžื•ืชืื ืื™ืฉื™ืช. ืืชื ื‘ื•ื—ืจื™ื ื—ืฉื‘ื•ืŸ ืฉื™ืจื•ืช ื‘ื”ืชืืžื” ืื™ืฉื™ืช ื›ืฉืืชื ื™ื•ืฆืจื™ื ืžืื’ืจ. ืืคืฉืจ ืœืขืจื•ืš ืืช ื—ืฉื‘ื•ืŸ ื”ืฉื™ืจื•ืช ืžืื•ื—ืจ ื™ื•ืชืจ.

ื ื™ื”ื•ืœ ื”ื’ืจืกืื•ืช

ื‘-Dataform ื ืขืฉื” ืฉื™ืžื•ืฉ ื‘ืžืขืจื›ืช ื ื™ื”ื•ืœ ื”ื’ืจืกืื•ืช ืฉืœ Git ื›ื“ื™ ืœืฉืžื•ืจ ืชื™ืขื•ื“ ืฉืœ ื›ืœ ืฉื™ื ื•ื™ ืฉื‘ื•ืฆืข ื‘ืงื•ื‘ืฆื™ ื”ืคืจื•ื™ืงื˜ ื•ืœื ื”ืœ ืืช ื’ืจืกืื•ืช ื”ืงื‘ืฆื™ื.

ื›ืœ ืžืื’ืจ Dataform ื™ื›ื•ืœ ืœื ื”ืœ ืžืื’ืจ Git ืžืฉืœื•, ืื• ืœื”ื™ื•ืช ืžื—ื•ื‘ืจ ืœืžืื’ืจ Git ืžืจื•ื—ืง. ืืชื ื™ื›ื•ืœื™ื ืœืงืฉืจ ืžืื’ืจ Dataform ืœืžืื’ืจ GitHub,โ€ GitLab,โ€ Azure DevOps Services,โ€ Bitbucket ืื• Secure Source Manager (ื”ืชืžื™ื›ื” ื‘-Secure Source Manager ื”ื™ื ื‘ื’ืจืกืช Preview).

ื”ืžืฉืชืžืฉื™ื ืžื ื”ืœื™ื ื’ืจืกืื•ืช ืฉืœ ืงื•ื“ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื‘ืกื‘ื™ื‘ื•ืช ื”ืขื‘ื•ื“ื” ืฉืœ Dataform. ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืฉืœ Dataform, ืืชื ื™ื›ื•ืœื™ื ืœืžืฉื•ืš ืฉื™ื ื•ื™ื™ื ืžื”ืžืื’ืจ, ืœื‘ืฆืข ืืช ื›ืœ ื”ืฉื™ื ื•ื™ื™ื ืื• ืจืง ื—ืœืง ืžื”ื, ื•ืœื“ื—ื•ืฃ ืื•ืชื ืœื”ืกืชืขืคื•ื™ื•ืช Git ืฉืœ ื”ืžืื’ืจ.

ืคื™ืชื•ื— ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื”

ื‘-Dataform, ืžื‘ืฆืขื™ื ืฉื™ื ื•ื™ื™ื ื‘ืงื‘ืฆื™ื ื•ื‘ืกืคืจื™ื•ืช ื‘ืชื•ืš ืกื‘ื™ื‘ืช ืคื™ืชื•ื—. ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื— ื”ื™ื ืขื•ืชืง ื•ื™ืจื˜ื•ืืœื™ ืฉืœ ืชื•ื›ืŸ ื‘ืžืื’ืจ Git, ืฉืืคืฉืจ ืœืขืจื•ืš ืื•ืชื•. โ€ซDataform ืฉื•ืžืจ ืืช ืžืฆื‘ ื”ืงื‘ืฆื™ื ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ืœืคื™ืชื•ื— ื‘ื™ืŸ ื”ืกืฉื ื™ื.

ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—, ืืชื ื™ื›ื•ืœื™ื ืœืคืชื— ืคืขื•ืœื•ืช ืฉืœ ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ื‘ืืžืฆืขื•ืช Dataform core ืขื SQLX ื•-JavaScript, ืื• ื‘ืืžืฆืขื•ืช JavaScript ื‘ืœื‘ื“. ืืชื ื™ื›ื•ืœื™ื ืœืขืฆื‘ ื‘ืื•ืคืŸ ืื•ื˜ื•ืžื˜ื™ ืืช ืงื•ื“ ื”ืœื™ื‘ื” ืฉืœ Dataform ืื• ืืช ืงื•ื“ ื”-JavaScript.

ื›ืœ ืจื›ื™ื‘ ื‘ืชื”ืœื™ืš ืขื‘ื•ื“ื” ืฉืœ Dataform, ื›ืžื• ื˜ื‘ืœื” ืื• ื˜ืขื ืช ื ื›ื•ึนื ื•ึผืช (assertion), ืชื•ืื ืœืคืขื•ืœื” ืฉ-Dataform ืžื‘ืฆืข ื‘-BigQuery. ืœื“ื•ื’ืžื”, ืงื•ื‘ืฅ ื”ื’ื“ืจืช ื˜ื‘ืœื” ื”ื•ื ืคืขื•ืœื” ืฉืœ ื™ืฆื™ืจื” ืื• ืขื“ื›ื•ืŸ ืฉืœ ื”ื˜ื‘ืœื” ื‘-BigQuery.

ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืฉืœ Dataform, ืืชื ื™ื›ื•ืœื™ื ืœืคืชื— ืืช ื”ืคืขื•ืœื•ืช ื”ื‘ืื•ืช ื‘ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื”:

ืืคืฉืจ ืœื”ืฉืชืžืฉ ื‘-JavaScript ื›ื“ื™ ืœืขืฉื•ืช ืฉื™ืžื•ืฉ ื—ื•ื–ืจ ื‘ืงื•ื“ ืฉืœ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื‘-Dataform ื‘ื“ืจื›ื™ื ื”ื‘ืื•ืช:

โ€ซDataform ืžื”ื“ืจ ืืช ืงื•ื“ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ื‘ื–ืžืŸ ืืžืช. ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ืืคืฉืจ ืœืจืื•ืช ืืช ื”ืฉืื™ืœืชื•ืช ืฉืขื‘ืจื• ื”ื™ื“ื•ืจ ื•ืืช ืคืจื˜ื™ ื”ืคืขื•ืœื•ืช ื‘ื›ืœ ืงื•ื‘ืฅ. ืืคืฉืจ ื’ื ืœืจืื•ืช ืืช ืกื˜ื˜ื•ืก ื”ื”ื™ื“ื•ืจ ื•ืืช ื”ืฉื’ื™ืื•ืช ื‘ืงื•ื‘ืฅ ื”ืขืจื•ืš ืื• ื‘ืžืื’ืจ.

ื›ื“ื™ ืœื‘ื“ื•ืง ืืช ื”ืคืœื˜ ืฉืœ ืฉืื™ืœืชืช SQL ืฉืขื‘ืจื” ืงื•ืžืคื™ืœืฆื™ื” ืœืคื ื™ ืฉืžืจื™ืฆื™ื ืื•ืชื” ื‘-BigQuery, ืืคืฉืจ ืœื”ืจื™ืฅ ืชืฆื•ื’ื” ืžืงื“ื™ืžื” ืฉืœ ื”ืฉืื™ืœืชื” ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ืฉืœ Dataform.

ื›ื“ื™ ืœื‘ื“ื•ืง ืืช ื›ืœ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ืฉื”ื•ื’ื“ืจ ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื”, ืืคืฉืจ ืœืจืื•ืช ื’ืจืฃ ืื™ื ื˜ืจืืงื˜ื™ื‘ื™ ืฉืขื‘ืจ ืงื•ืžืคื™ืœืฆื™ื” ืฉื‘ื• ืžื•ืฆื’ื•ืช ื›ืœ ื”ืคืขื•ืœื•ืช ืฉืขื‘ืจื• ืงื•ืžืคื™ืœืฆื™ื” ื‘ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื•ื”ืงืฉืจื™ื ื‘ื™ื ื™ื”ืŸ.

ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ ืชื”ืœื™ืš ืขื‘ื•ื“ื”

โ€ซDataform ืžืฉืชืžืฉ ื‘ื”ื’ื“ืจื•ืช ืงื•ืžืคื™ืœืฆื™ื” ืฉืžื•ื’ื“ืจื•ืช ื›ื‘ืจื™ืจืช ืžื—ื“ืœ, ื‘ืงื•ื‘ืฅ ื”ื”ื’ื“ืจื•ืช ืฉืœ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื”, ื›ื“ื™ ืœื‘ืฆืข ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ ืงื•ื“ ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ืœ-SQL ื‘ื–ืžืŸ ืืžืช, ื•ื›ืš ืœื™ืฆื•ืจ ืชื•ืฆืืช ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื”.

ืืชื ื™ื›ื•ืœื™ื ืœืฉื ื•ืช ืืช ื”ื’ื“ืจื•ืช ื”-compilation ื›ื“ื™ ืœื”ืชืื™ื ืื™ืฉื™ืช ืืช ื”ืื•ืคืŸ ืฉื‘ื• Dataform ืžืงืžืคืœ ืืช ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ืœืชื•ืฆืืช compilation.

ื‘ืขื–ืจืช ืฉื™ื ื•ื™ ื”ื’ื“ืจื•ืช ื‘ืจื™ืจืช ื”ืžื—ื“ืœ ืฉืœ ื”ื™ื“ื•ืจ ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื”, ืืชื ื™ื›ื•ืœื™ื ืœื”ื’ื“ื™ืจ ืฉื™ื ื•ื™ื™ื ื‘ื”ื’ื“ืจื•ืช ื‘ืจื™ืจืช ื”ืžื—ื“ืœ ืฉืœ ื”ื™ื“ื•ืจ ืœื›ืœ ืกื‘ื™ื‘ื•ืช ื”ืขื‘ื•ื“ื” ื‘ืžืื’ืจ. ืืชื ื™ื›ื•ืœื™ื ืœื”ื’ื“ื™ืจ ืฉื™ื ื•ื™ื™ื ื“ื™ื ืžื™ื™ื ื‘ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื” ื›ื“ื™ ืœื™ืฆื•ืจ ืชื•ืฆืื•ืช ืงื•ืžืคื™ืœืฆื™ื” ื‘ื”ืชืืžื” ืื™ืฉื™ืช ืœื›ืœ ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื”, ื•ื›ืš ืœื”ืคื•ืš ืืช ืกื‘ื™ื‘ื•ืช ื”ืขื‘ื•ื“ื” ืœืกื‘ื™ื‘ื•ืช ืคื™ืชื•ื— ืžื‘ื•ื“ื“ื•ืช. ืืชื ื™ื›ื•ืœื™ื ืœืฉื ื•ืช ืืช ืคืจื•ื™ืงื˜ Google Cloud ืฉื‘ื• Dataform ืžืจื™ืฅ ืืช ื”ืชื•ื›ืŸ ืฉืœ ืกื‘ื™ื‘ืช ื”ืขื‘ื•ื“ื”, ืœื”ื•ืกื™ืฃ ืงื™ื“ื•ืžืช ืœืฉืžื•ืช ืฉืœ ื›ืœ ื”ื˜ื‘ืœืื•ืช ืฉืขื‘ืจื• ื”ื™ื“ื•ืจ ื•ืœื”ื•ืกื™ืฃ ืกื™ื•ืžืช ืœืกื›ื™ืžื” ืฉืžื•ื’ื“ืจืช ื›ื‘ืจื™ืจืช ืžื—ื“ืœ.

ื”ื’ื“ืจื•ืช ื”ืคืฆื” ืžืืคืฉืจื•ืช ืœื›ื ืœื”ื’ื“ื™ืจ ืชื‘ื ื™ื•ืช ืฉืœ ื”ื’ื“ืจื•ืช ื”ื™ื“ื•ืจ (compilation) ื›ื“ื™ ืœื™ืฆื•ืจ ืชื•ืฆืื•ืช ื”ื™ื“ื•ืจ ืฉืœ ืžืื’ืจ Dataform. ื‘ื”ื’ื“ืจืช ื’ืจืกื”, ืืคืฉืจ ืœืฉื ื•ืช ืืช ืคืจื•ื™ืงื˜ Google Cloud ืฉื‘ื• Dataform ืžืจื™ืฅ ืืช ืชื•ืฆืื•ืช ื”ืงื•ืžืคื™ืœืฆื™ื”, ืœื”ื•ืกื™ืฃ ืงื™ื“ื•ืžืช ืœืฉืžื•ืช ืฉืœ ื›ืœ ื”ื˜ื‘ืœืื•ืช ืฉืขื‘ืจื• ืงื•ืžืคื™ืœืฆื™ื”, ืœื”ื•ืกื™ืฃ ืกื™ื•ืžืช ืœืกื›ื™ืžืช ื‘ืจื™ืจืช ื”ืžื—ื“ืœ ื•ืœื”ื•ืกื™ืฃ ืžืฉืชื ื™ ืงื•ืžืคื™ืœืฆื™ื”. ืืคืฉืจ ื’ื ืœื”ื’ื“ื™ืจ ืืช ื”ืชื“ื™ืจื•ืช ืฉืœ ื™ืฆื™ืจืช ืชื•ืฆืื•ืช ื”ื”ื™ื“ื•ืจ. ื›ื“ื™ ืœืชื–ืžืŸ ื”ืจืฆื•ืช ืฉืœ ืชื•ืฆืื•ืช ืงื•ืžืคื™ืœืฆื™ื” ืฉื ื•ืฆืจื• ื‘ื”ื’ื“ืจืช ืคืจื™ื˜ ืชื•ื›ืŸ ื ื‘ื—ืจ, ืืคืฉืจ ืœื™ืฆื•ืจ ื”ื’ื“ืจืช ืชื”ืœื™ืš ืขื‘ื•ื“ื”.

ื”ืจืฆื” ืฉืœ ืชื”ืœื™ืš ืขื‘ื•ื“ื”

ื‘ืžื”ืœืš ื”ืคืขืœืช ืชื”ืœื™ืš ืขื‘ื•ื“ื”, Dataform ืžืจื™ืฅ ืืช ืชื•ืฆืื•ืช ื”ื”ื™ื“ื•ืจ ืฉืœ ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ื›ื“ื™ ืœื™ืฆื•ืจ ืื• ืœืขื“ื›ืŸ ื ื›ืกื™ื ื‘-BigQuery.

ื›ื“ื™ ืœื™ืฆื•ืจ ืื• ืœืจืขื ืŸ ืืช ื”ื˜ื‘ืœืื•ืช ื•ื”ืชืฆื•ื’ื•ืช ืฉื”ื•ื’ื“ืจื• ื‘ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื‘-BigQuery, ืืชื ื™ื›ื•ืœื™ื ืœื”ืคืขื™ืœ ื™ื“ื ื™ืช ืืช ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ื‘ืกื‘ื™ื‘ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื— ืื• ืœืชื–ืžืŸ ื”ืคืขืœื•ืช.

ื›ืฉืžืคืขื™ืœื™ื ื”ืจืฆื” ืฉืœ ืชื”ืœื™ืš ืขื‘ื•ื“ื”, Dataform ืžื‘ืฆืข ืืช ื”ืคืขื•ืœื•ืช ืœืคื™ ื”ืกื“ืจ ืฉืžื•ื’ื“ืจ ื‘ื™ื—ืกื™ ื”ืชืœื•ืช ืฉืœื”ืŸ. ืœื›ืœ ืคืขื•ืœื”, Dataform ืžื‘ืฆืข ืืช ื”ืฉืœื‘ื™ื ื”ื‘ืื™ื:

  1. ืžืจื™ืฅ ืืช ื”-SQL ื”ืžืงื•ืžืคืœ ื‘-BigQuery.
  2. ืžืขื“ื›ื ืช ืืช ืกื˜ื˜ื•ืก ื”ืคืขื•ืœื” ื‘ื™ื•ืžืŸ ื”ื‘ื™ืฆื•ืข.
  3. ืื—ืจื™ ืฉืคืขื•ืœื” ืžืกืชื™ื™ืžืช ื‘ื”ืฆืœื—ื”, Dataform ืžืคืขื™ืœ ื‘ืื•ืคืŸ ืื•ื˜ื•ืžื˜ื™ ืกื ื›ืจื•ืŸ ืฉืœ ืžื˜ื-ื ืชื•ื ื™ื ืขื Knowledge Catalog. ืชื”ืœื™ืš ื”ื”ืขืฉืจื” ื”ื–ื” ืžืขื“ื›ืŸ ืืช Knowledge Catalog ื‘ืžื˜ื-ื ืชื•ื ื™ื ื”ืกืžื ื˜ื™ื™ื ืฉืžื•ื’ื“ืจื™ื ื‘ืชืฆื•ืจืช SQLX. ื”ืกื ื›ืจื•ืŸ ืžืชื‘ืฆืข ื‘ืื•ืคืŸ ืืกื™ื ื›ืจื•ื ื™ ื•ืžืฉืชืžืฉ ื‘ืžื ื’ื ื•ืŸ ืฉืœ ื ื™ืกื™ื•ืŸ ื—ื•ื–ืจ, ื›ื“ื™ ืœื•ื•ื“ื ืฉืขื“ื›ื•ื ื™ ื”ืžื˜ื-ื ืชื•ื ื™ื ืœื ืžืฉืคื™ืขื™ื ืขืœ ื–ืžืŸ ื”ืื—ื–ื•ืจ ืฉืœ ืฆื™ื ื•ืจ ืขื™ื‘ื•ื“ ื”ื ืชื•ื ื™ื ืื• ื’ื•ืจืžื™ื ืœื›ืฉืœื™ื ื‘ืชื”ืœื™ืš ื”ืขื‘ื•ื“ื” ืื Dataplex API ืœื ื–ืžื™ืŸ ื‘ืื•ืคืŸ ื–ืžื ื™.

ืืชื ื™ื›ื•ืœื™ื ืœืชื–ืžืŸ ื”ืคืขืœื•ืช ืฉืœ Dataform ื‘-BigQuery ื‘ื“ืจื›ื™ื ื”ื‘ืื•ืช:

ืืคืฉืจ ื’ื ืœื”ืคื•ืš ืืช ื”ื”ืจืฆื•ืช ืœืื•ื˜ื•ืžื˜ื™ื•ืช ื‘ืืžืฆืขื•ืช ื˜ืจื™ื’ืจื™ื ืฉืœ Cloud Build.

ื›ื“ื™ ืœื ืคื•ืช ื‘ืื’ื™ื ื‘ืฉื’ื™ืื•ืช, ืืคืฉืจ ืœืขืงื•ื‘ ืื—ืจื™ ื”ื”ืจืฆื•ืช ื‘ื“ืจื›ื™ื ื”ื‘ืื•ืช:

Dataform core

โ€ซDataform core ื”ื™ื ืฉืคืช-ืขืœ ืžื‘ื•ืกืกืช ืงื•ื“ ืคืชื•ื— ืœื™ืฆื™ืจืช ื˜ื‘ืœืื•ืช ื•ื–ืจื™ืžื•ืช ืขื‘ื•ื“ื” ืฉืœ SQL. โ€ซDataform Core ืžืจื—ื™ื‘ ืืช SQL ืขืœ ื™ื“ื™ ืžืชืŸ ืžืขืจื›ืช ืœื ื™ื”ื•ืœ ืชืœื•ืช, ื‘ื“ื™ืงื•ืช ืื•ื˜ื•ืžื˜ื™ื•ืช ืฉืœ ืื™ื›ื•ืช ื”ื ืชื•ื ื™ื ื•ืชื™ืขื•ื“ ื ืชื•ื ื™ื.

ืืคืฉืจ ืœื”ืฉืชืžืฉ ื‘-Dataform core ืœืžื˜ืจื•ืช ื”ื‘ืื•ืช:

  • ื”ื’ื“ืจืช ื˜ื‘ืœืื•ืช, ืชืฆื•ื’ื•ืช, ืชืฆื•ื’ื•ืช ืžื”ื•ืชื™ื•ืช ืื• ื˜ื‘ืœืื•ืช ืžืฆื˜ื‘ืจื•ืช.
  • ื”ื’ื“ืจืช ื”ืœื•ื’ื™ืงื” ืฉืœ ื˜ืจื ืกืคื•ืจืžืฆื™ื™ืช ื”ื ืชื•ื ื™ื.
  • ื”ืฆื”ืจื” ืขืœ ื ืชื•ื ื™ ืžืงื•ืจ ื•ื ื™ื”ื•ืœ ืฉืœ ื™ื—ืกื™ ืชืœื•ืช ื‘ื™ืŸ ื˜ื‘ืœืื•ืช.
  • ืชื™ืขื•ื“ ืฉืœ ืชื™ืื•ืจื™ ื”ื˜ื‘ืœื” ื•ื”ืขืžื•ื“ื•ืช ื‘ืชื•ืš ื”ืงื•ื“.
  • ืฉื™ืžื•ืฉ ื—ื•ื–ืจ ื‘ืคื•ื ืงืฆื™ื•ืช ื•ื‘ืžืฉืชื ื™ื ื‘ืฉืื™ืœืชื•ืช ืฉื•ื ื•ืช.
  • ื›ืชื™ื‘ืช ื˜ืขื ื•ืช ื ื›ื•ื ื•ืช (assertions) ืฉืœ ื ืชื•ื ื™ื ื›ื“ื™ ืœืืžืช ืืช ืขืงื‘ื™ื•ืช ื”ื ืชื•ื ื™ื.

ื‘-Dataform, ืžืฉืชืžืฉื™ื ื‘ืœื™ื‘ื” ืฉืœ Dataform ื›ื“ื™ ืœืคืชื— ืชื”ืœื™ื›ื™ ืขื‘ื•ื“ื” ื•ืœืคืจื•ืก ื ื›ืกื™ื ื‘-BigQuery.

ื”ืœื™ื‘ื” ืฉืœ Dataform ื”ื™ื ื—ืœืง ืžืžืกื’ืจืช ืžื•ื“ืœื™ื ืฉืœ ื ืชื•ื ื™ื ื‘-Dataform ื‘ืงื•ื“ ืคืชื•ื—, ืฉื›ื•ืœืœืช ื’ื ืืช Dataform CLI. ืืชื ื™ื›ื•ืœื™ื ืœื”ื“ืจ ื•ืœื”ืจื™ืฅ ืืช Dataform Core ื‘ืื•ืคืŸ ืžืงื•ืžื™ ื‘ืืžืฆืขื•ืช Dataform CLI ืžื—ื•ืฅ ืœ- Google Cloud.

ื›ื“ื™ ืœื”ืฉืชืžืฉ ื‘-Dataform core, ืฆืจื™ืš ืœื›ืชื•ื‘ ืงื•ื‘ืฆื™ SQLX. ื›ืœ ืงื•ื‘ืฅ SQLX ืžื›ื™ืœ ืฉืื™ืœืชื” ืฉืžื’ื“ื™ืจื” ืงืฉืจ ื‘ื™ืŸ ืžืกื“ื™ ื ืชื•ื ื™ื ืฉ-Dataform ื™ื•ืฆืจ ื•ืžืขื“ื›ืŸ ื‘-BigQuery.

โ€ซDataform ืžืงืžืคืœ ืืช ืงื•ื“ ื”ืœื™ื‘ื” ืฉืœ Dataform ื‘ื–ืžืŸ ืืžืช ื›ื“ื™ ืœื™ืฆื•ืจ ืชื•ืฆืืช ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ SQL ืฉืืคืฉืจ ืœื”ืจื™ืฅ ื‘-BigQuery.

ื”ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ Dataform ื”ื™ื ื”ืจืžื˜ื™ืช ื›ื“ื™ ืœืืžืช ืืช ื”ืขืงื‘ื™ื•ืช ืฉืœื”, ื›ืœื•ืžืจ ืื•ืชื• ืงื•ื“ ืขื•ื‘ืจ ืงื•ืžืคื™ืœืฆื™ื” ืœืื•ืชื” ืชื•ืฆืืช ืงื•ืžืคื™ืœืฆื™ื” ืฉืœ SQL ื‘ื›ืœ ืคืขื. โ€ซDataform ืžื”ื“ืจ ืืช ื”ืงื•ื“ ืฉืœื›ื ื‘ืกื‘ื™ื‘ืช ืืจื’ื– ื—ื•ืœ ืœืœื ื’ื™ืฉื” ืœืื™ื ื˜ืจื ื˜. ื‘ืžื”ืœืš ื”ื”ื™ื“ื•ืจ ืœื ื–ืžื™ื ื•ืช ืคืขื•ืœื•ืช ื ื•ืกืคื•ืช, ื›ืžื• ืงืจื™ืื” ืœืžืžืฉืงื™ API ื—ื™ืฆื•ื ื™ื™ื.

ื‘ืœื•ืง ื”ื”ื’ื“ืจื•ืช ืฉืœ ืงื•ื‘ืฅ SQLX

ืงื•ื‘ืฅ SQLX ืžื•ืจื›ื‘ ืžื‘ืœื•ืง config ื•ืžื’ื•ืฃ. ื›ืœ ืžืืคื™ื™ื ื™ ื”ื”ื’ื“ืจื” ื•ื‘ืœื•ืง ื”ื”ื’ื“ืจื” ืขืฆืžื• ื”ื ืื•ืคืฆื™ื•ื ืœื™ื™ื. ืœื›ืŸ, ื›ืœ ืงื•ื‘ืฅ SQL ืจื’ื™ืœ ื”ื•ื ืงื•ื‘ืฅ SQLX ืชืงื™ืŸ ืฉ-Dataform ืžืจื™ืฅ ื›ืžื• ืฉื”ื•ื.

ื‘ื‘ืœื•ืง ื”ื”ื’ื“ืจื•ืช, ืืคืฉืจ ืœื‘ืฆืข ืืช ื”ืคืขื•ืœื•ืช ื”ื‘ืื•ืช:

ืฆื™ื•ืŸ ืžื˜ื-ื ืชื•ื ื™ื ืฉืœ ืฉืื™ืœืชื”

ืืชื ื™ื›ื•ืœื™ื ืœื”ื’ื“ื™ืจ ืื™ืš Dataform ื™ื•ืฆืจืช ืชืฆื•ื’ื•ืช ื—ื•ืžืจื™ื•ืช ืฉืœ ืฉืื™ืœืชื•ืช ื‘-BigQuery, ืœืžืฉืœ ืกื•ื’ ื˜ื‘ืœืช ื”ืคืœื˜, ืžืกื“ ื”ื ืชื•ื ื™ื ืฉืœ ื”ื™ืขื“ ืื• ืชื•ื•ื™ื•ืช, ื‘ืืžืฆืขื•ืช ืžื˜ื-ื ืชื•ื ื™ื ืฉืœ ื”ื’ื“ืจื•ืช.

ื ืชื•ื ื™ ืžืกืžื›ื™ื

ืืคืฉืจ ืœืชืขื“ ืืช ื”ื˜ื‘ืœืื•ืช ื•ืืช ื”ืฉื“ื•ืช ืฉืœื”ืŸ ื™ืฉื™ืจื•ืช ื‘ื‘ืœื•ืง config. ื”ืชื™ืขื•ื“ ืฉืœ ื”ื˜ื‘ืœืื•ืช ื ืฉืœื— ื™ืฉื™ืจื•ืช ืœ-BigQuery ื•ืœ-Knowledge Catalog. ืืชื ื™ื›ื•ืœื™ื ืœื ืชื— ืืช ื”ืชื™ืขื•ื“ ื”ื–ื” ื•ืœื”ืขื‘ื™ืจ ืื•ืชื• ืœื›ืœื™ื ืื—ืจื™ื.

ื‘ื“ื•ื’ืžืช ื”ืงื•ื“ ื”ื‘ืื” ืžื•ืกื‘ืจ ืื™ืš ืœื”ื’ื“ื™ืจ ืืช ืกื•ื’ ื˜ื‘ืœืช ื”ืคืœื˜, ืœืชืขื“ ืืช ื”ื˜ื‘ืœื” ื•ืœื”ื•ืกื™ืฃ ืžื˜ื-ื ืชื•ื ื™ื ืœ-Knowledge Catalog ื‘ื‘ืœื•ืง config ืฉืœ ืงื•ื‘ืฅ SQLX:

config {
  type: "table",
  description: "This table joins orders information from OnlineStore & payment information from PaymentApp",
  columns: {
    order_date: "The date when a customer placed their order",
    id: "Order ID as defined by OnlineStore",
    order_status: "The status of an order, for example, sent, delivered",
    customer_id: "Unique customer ID",
    payment_status: "The status of a payment, for example, pending, paid",
    payment_method: "How the customer chose to pay",
    item_count: "The number of items the customer ordered",
    amount: "The amount the customer paid"
  },
  metadata: {
    overview: "This table provides joined orders and payment data.",
    extraProperties: {
      generic: {
        system: "BigQuery",
        type: "table"
      }
    }
  }
}

ื”ื’ื“ืจืช ื‘ื“ื™ืงื•ืช ืœืื™ื›ื•ืช ื”ื ืชื•ื ื™ื

ืืชื ื™ื›ื•ืœื™ื ืœื”ื’ื“ื™ืจ ื‘ื“ื™ืงื•ืช ืœืื™ื›ื•ืช ื”ื ืชื•ื ื™ื, ืฉื ืงืจืื•ืช ื˜ืขื ื•ืช ื ื›ื•ื ื•ืช (assertions), ื›ื“ื™ ืœื‘ื“ื•ืง ืื ื™ืฉ ืขืจื›ื™ื ื™ื™ื—ื•ื“ื™ื™ื, ืขืจื›ื™ null ืื• ืชื ืื™ ื‘ื”ืชืืžื” ืื™ืฉื™ืช. ืื—ืจื™ ื™ืฆื™ืจืช ื”ื˜ื‘ืœื”, Dataform ืžื•ืกื™ืฃ ืืช ื”ื˜ืขื ื•ืช ืฉืžื•ื’ื“ืจื•ืช ื‘ื‘ืœื•ืง ื”ื”ื’ื“ืจื•ืช ืœืขืฅ ื”ืชืœื•ืช ืฉืœ ื–ืจื™ืžืช ื”ืขื‘ื•ื“ื”. ืืคืฉืจ ื’ื ืœื”ื’ื“ื™ืจ ื˜ืขื ื•ืช ื ื›ื•ื ื•ืช (assertions) ืžื—ื•ืฅ ืœื‘ืœื•ืง config, ื‘ืงื•ื‘ืฅ SQLX ื ืคืจื“.

ื‘ื“ื•ื’ืžืช ื”ืงื•ื“ ื”ื‘ืื” ืืคืฉืจ ืœืจืื•ืช ืื™ืš ืžื’ื“ื™ืจื™ื ื‘ื“ื™ืงืช ืื™ื›ื•ืช ื‘ื‘ืœื•ืง ื”ื’ื“ืจื•ืช ื‘ืงื•ื‘ืฅ SQLX:

config {
  assertions: {
    uniqueKey: ["id"]
  }
}

ื’ื•ืฃ ื”ืงื•ื‘ืฅ ืฉืœ SQLX

ื‘ื’ื•ืฃ ืฉืœ ืงื•ื‘ืฅ SQLX, ืืชื ื™ื›ื•ืœื™ื ืœื‘ืฆืข ืืช ื”ืคืขื•ืœื•ืช ื”ื‘ืื•ืช:

ื”ื’ื“ืจืช ื˜ื‘ืœื”

ื›ื“ื™ ืœื”ื’ื“ื™ืจ ื˜ื‘ืœื” ื—ื“ืฉื”, ืืคืฉืจ ืœื”ืฉืชืžืฉ ื‘ื”ืฆื”ืจื•ืช SQL SELECT ื•ื‘ืคื•ื ืงืฆื™ื” ref.

ื”ืคื•ื ืงืฆื™ื” ref ื”ื™ื ืคื•ื ืงืฆื™ื” ืžื•ื‘ื ื™ืช ืฉืœ SQLX ืฉื—ื™ื•ื ื™ืช ืœื ื™ื”ื•ืœ ื™ื—ืกื™ ืชืœื•ืช ื‘-Dataform. ื”ืคื•ื ืงืฆื™ื” ref ืžืืคืฉืจืช ืœื”ืคื ื•ืช ืœื˜ื‘ืœืื•ืช ืฉื”ื•ื’ื“ืจื• ื‘ืคืจื•ื™ืงื˜ Dataform, ื‘ืžืงื•ื ืœื”ื’ื“ื™ืจ ืงื™ื“ื•ื“ ืงืฉื™ื— ืฉืœ ื”ืกื›ื™ืžื” ื•ืฉืžื•ืช ื”ื˜ื‘ืœืื•ืช ืฉืœ ื˜ื‘ืœืช ื”ื ืชื•ื ื™ื.

โ€ซDataform ืžืฉืชืžืฉ ื‘ืคื•ื ืงืฆื™ื” ref ื›ื“ื™ ืœื™ืฆื•ืจ ืขืฅ ืชืœื•ืช ืฉืœ ื›ืœ ื”ื˜ื‘ืœืื•ืช ืฉืฆืจื™ืš ืœื™ืฆื•ืจ ืื• ืœืขื“ื›ืŸ. ืื—ืจื™ ื”ื”ื™ื“ื•ืจ, Dataform ืžื•ืกื™ืฃ ื”ืฆื”ืจื•ืช ืกื˜ื ื“ืจื˜ื™ื•ืช ื›ืžื• CREATE, REPLACE ืื• INSERT.

ื‘ื“ื•ื’ืžืช ื”ืงื•ื“ ื”ื‘ืื” ืืคืฉืจ ืœืจืื•ืช ืื™ืš ืžืคื ื™ื ืœื˜ื‘ืœื” ื‘ืงื•ื‘ืฅ SQLX ื‘ืืžืฆืขื•ืช ื”ืคื•ื ืงืฆื™ื” ref.

config { type: "table" }

SELECT
  order_date AS date,
  order_id AS order_id,
  order_status AS order_status,
  SUM(item_count) AS item_count,
  SUM(amount) AS revenue

FROM ${ref("store_clean")}

GROUP BY 1, 2, 3

ื”ืคืœื˜ ืืžื•ืจ ืœื”ื™ืจืื•ืช ื›ืš:

CREATE OR REPLACE TABLE Dataform.orders AS

SELECT
  order_date AS date,
  order_id AS order_id,
  order_status AS order_status,
  SUM(item_count) AS item_count,
  SUM(amount) AS revenue

FROM Dataform_stg.store_clean

GROUP BY 1, 2, 3

ืžื™ื“ืข ื ื•ืกืฃ ืขืœ ื ื™ื”ื•ืœ ืชืœื•ืช ื ื•ืกืฃ, ืœืžืฉืœ ืขืœ ื”ืคืขืœื” ืฉืœ ืงื•ื“ ื‘ืชื ืื™, ื‘ืืžืฆืขื•ืช ืคื•ื ืงืฆื™ื•ืช ืžื•ื‘ื ื•ืช ืื—ืจื•ืช ืฉืœ Dataform Core, ื–ืžื™ืŸ ื‘ืžืืžืจ Dataform Core reference.

ื”ื’ื“ืจืช ืคืขื•ืœื•ืช SQL ื ื•ืกืคื•ืช

ื›ื“ื™ ืœื”ื’ื“ื™ืจ ืืช Dataform ืœื”ืจื™ืฅ ื”ืฆื”ืจืช SQL ืื—ืช ืื• ื™ื•ืชืจ ืœืคื ื™ ืื• ืื—ืจื™ ื™ืฆื™ืจืช ื˜ื‘ืœื” ืื• ืชืฆื•ื’ื”, ืืชื ื™ื›ื•ืœื™ื ืœืฆื™ื™ืŸ ืคืขื•ืœื•ืช ืœืคื ื™ ืฉืื™ืœืชื” ื•ืื—ืจื™ ืฉืื™ืœืชื”.

ื‘ื“ื•ื’ืžืช ื”ืงื•ื“ ื”ื‘ืื” ืืคืฉืจ ืœืจืื•ืช ืื™ืš ืžื’ื“ื™ืจื™ื ื”ืจืฉืื•ืช ื’ื™ืฉื” ืœื˜ื‘ืœื” ืื• ืœืชืฆื•ื’ื” ื‘ืคืขื•ืœื” ืฉืื—ืจื™ ืฉืื™ืœืชื”.

SELECT * FROM ...

post_operations {
  GRANT `roles/bigquery.dataViewer` ON TABLE ${self()} TO "group:someusers@dataform.co"
}

ืื ืงืคืกื•ืœืฆื™ื” ืฉืœ ืงื•ื“ SQL

ื›ื“ื™ ืœื”ื’ื“ื™ืจ ืคื•ื ืงืฆื™ื•ืช ืฉืืคืฉืจ ืœื”ืฉืชืžืฉ ื‘ื”ืŸ ืฉื•ื‘ ื•ืฉื•ื‘ ืœื™ืฆื™ืจืช ื—ืœืงื™ื ื—ื•ื–ืจื™ื ืฉืœ ืงื•ื“ SQL, ืืชื ื™ื›ื•ืœื™ื ืœื”ืฉืชืžืฉ ื‘ื‘ืœื•ืงื™ื ืฉืœ JavaScript. ืืคืฉืจ ืœื”ืฉืชืžืฉ ืฉื•ื‘ ื‘ืงื•ื“ ืฉืžื•ื’ื“ืจ ื‘ื‘ืœื•ืง JavaScript ืจืง ื‘ืชื•ืš ืงื•ื‘ืฅ ื”-SQLX ืฉื‘ื• ื”ื‘ืœื•ืง ืžื•ื’ื“ืจ. ื›ื“ื™ ืœืขืฉื•ืช ืฉื™ืžื•ืฉ ื—ื•ื–ืจ ื‘ืงื•ื“ ื‘ื›ืœ ื”ืžืื’ืจ, ืืคืฉืจ ืœื™ืฆื•ืจ ื”ื›ืœืœื•ืช.

ื›ื“ื™ ืœืฉื ื•ืช ืฉืื™ืœืชื” ื‘ืื•ืคืŸ ื“ื™ื ืžื™, ืืคืฉืจ ืœื”ืฉืชืžืฉ ื‘-JavaScript ืžื•ื˜ื‘ืข ื‘ื›ืœ ืžืงื•ื ื‘ื’ื•ืฃ.

ื‘ื“ื•ื’ืžืช ื”ืงื•ื“ ื”ื‘ืื” ืืคืฉืจ ืœืจืื•ืช ืื™ืš ืžื’ื“ื™ืจื™ื ื‘ืœื•ืง JavaScript ื‘ืงื•ื‘ืฅ SQLX ื•ืžืฉืชืžืฉื™ื ื‘ื• ื‘ืฉื•ืจื” ื‘ืชื•ืš ืฉืื™ืœืชื”:

js {
  const columnName = "foo";
}

SELECT 1 AS ${columnName} FROM "..."

ืžื’ื‘ืœื•ืช

ืืœื” ื”ืžื’ื‘ืœื•ืช ื”ื™ื“ื•ืขื•ืช ืฉืœ Dataform:

  • โ€ซDataform Google Cloud ืคื•ืขืœ ื‘ืกื‘ื™ื‘ืช ื–ืžืŸ ืจื™ืฆื” ืจื’ื™ืœื” ืฉืœ V8 ื•ืœื ืชื•ืžืš ื‘ื™ื›ื•ืœื•ืช ื•ื‘ืžื•ื“ื•ืœื™ื ื ื•ืกืคื™ื ืฉืžืกื•ืคืงื™ื ืขืœ ื™ื“ื™ Node.js. ืื ื‘ืกื™ืก ื”ืงื•ื“ ื”ืงื™ื™ื ืฉืœื›ื ื“ื•ืจืฉ ืžื•ื“ื•ืœื™ื ืฉืœ Node.js, ืชืฆื˜ืจื›ื• ืœื”ืกื™ืจ ืืช ื”ืชืœื•ืช ื”ื–ื•.

    ื‘ืคืจื•ื™ืงื˜ื™ื ืฉืื™ืŸ ื‘ื”ื ืฉื“ื” ืฉื ื‘-package.json, ื ื•ืฆืจื™ื ื”ื‘ื“ืœื™ื ื‘-package-lock.json ื‘ื›ืœ ืคืขื ืฉืžืชืงื™ื ื™ื ื—ื‘ื™ืœื•ืช. ื›ื“ื™ ืœื”ื™ืžื ืข ืžื›ืš, ืฆืจื™ืš ืœื”ื•ืกื™ืฃ ื ื›ืก name ื‘-package.json.

  • ืื™ืŸ ืชืžื™ื›ื” ื‘ื›ืชื•ื‘ื•ืช URL ืฉืœ ื™ื—ืกื™ ืชืœื•ืช ื‘-package.json ืขื git+https://.

    ืฆืจื™ืš ืœื”ืžื™ืจ ื›ืชื•ื‘ื•ืช URL ื›ืืœื” ืœื›ืชื•ื‘ื•ืช URL ืคืฉื•ื˜ื•ืช ืฉืœ ืืจื›ื™ื•ืŸ https://. ืœื“ื•ื’ืžื”, ืœื”ืžื™ืจ ืืช git+https://github.com/dataform-co/dataform-segment.git#1.5 ืœ-https://github.com/dataform-co/dataform-segment/archive/1.5.tar.gz.

  • ืื™ ืืคืฉืจ ืœื”ืจื™ืฅ ื‘ื“ื™ืงื•ืช ื™ื—ื™ื“ื” ื‘ืื•ืคืŸ ื™ื“ื ื™.

  • ืื™ ืืคืฉืจ ืœื—ืคืฉ ืชื•ื›ืŸ ืฉืœ ืงื‘ืฆื™ื ื‘ืกื‘ื™ื‘ื•ืช ืขื‘ื•ื“ื” ืœืคื™ืชื•ื—.

  • ื”ื—ืœ ืžื’ืจืกื” 3.0.0. ืฉืœ Dataform core, โ€Dataform ืœื ืžืคื™ืฅ ืงื•ื‘ืฅ ืื™ืžื’' ืฉืœ Docker. ืืชื ื™ื›ื•ืœื™ื ืœื™ืฆื•ืจ ืงื•ื‘ืฅ ืื™ืžื’' ืฉืœ Docker ืžืฉืœื›ื ืฉืœ Dataform, ืฉื‘ื• ืชื•ื›ืœื• ืœื”ืฉืชืžืฉ ื›ื“ื™ ืœื”ืจื™ืฅ ืคืงื•ื“ื•ืช ืฉื•ื•ืช ืขืจืš ืฉืœ Dataform CLI. ื›ื“ื™ ืœื™ืฆื•ืจ ืงื•ื‘ืฅ ืื™ืžื’' ืžืฉืœื›ื ื‘-Docker, ืืคืฉืจ ืœืขื™ื™ืŸ ื‘ืžืืžืจ ื”ืขื‘ืจืช ืืคืœื™ืงืฆื™ื” ืœืงื•ื ื˜ื™ื™ื ืจ ื‘ืžืกืžื›ื™ ื”ืชื™ืขื•ื“ ืฉืœ Docker.

  • ื”ืฉื™ื˜ื•ืช ื”ื‘ืื•ืช ืฉืœ Dataform API ืœื ืชื•ืืžื•ืช ืœื”ื ื—ื™ื•ืช ืฉืœ AIP.134, ื›ื™ ื”ืŸ ืžืชื™ื™ื—ืกื•ืช ืœืชื• ื”ื›ืœืœื™ ืœื—ื™ืคื•ืฉ * ื›ื‘ืงืฉื” ืฉื’ื•ื™ื”, ื•ืžืขื“ื›ื ื•ืช ืืช ื›ืœ ื”ืฉื“ื•ืช ื‘ืžืงื•ื ืืช ื”ืฉื“ื•ืช ืฉื”ื•ื’ื“ืจื• ื›ืฉืžืฉืžื™ื˜ื™ื ืืช field_mask:

  • ืื ื”ืคืขืœื” ืžืชื•ื–ืžื ืช ืฉืœ ื”ื’ื“ืจืช ืชื”ืœื™ืš ืขื‘ื•ื“ื” ืœื ืžืกืชื™ื™ืžืช ืœืคื ื™ ืชื—ื™ืœืช ื”ื”ืคืขืœื” ื”ืžืชื•ื–ืžื ืช ื”ื‘ืื”, ื”ืžืขืจื›ืช ืžื“ืœื’ืช ืขืœ ื”ื”ืคืขืœื” ื”ืžืชื•ื–ืžื ืช ื”ื‘ืื” ื•ืžืกืžื ืช ืื•ืชื” ื‘ืฉื’ื™ืื”.

ื”ืžืืžืจื™ื ื”ื‘ืื™ื