Square package

This dbt package:

• Contains a DBT dimensional model based on Square data from DataLakeHouse.io connector.
• The main use of this package is to provide a stable Snowflake dimensional model that will provide useful insights.

Models

The primary ouputs of this package are fact and dimension tables as listed below. There are several intermediate models used to create these models. Documentation can be found here.

Type	Model	Raw tables involved
Dimension	W_SQR_CATALOG_ITEM_D	CATALOG_CATEGORY CATALOG_MODIFIER CATALOG_ITEM_VARIATION CATALOG_ITEM ORDER_LINE_ITEM
Dimension	W_SQR_CURRENCY_D	Manually built
Dimension	W_SQR_MERCHANT_LOCATION_D	LOCATION
Dimension	W_SQR_CUSTOMERS_D	CUSTOMER
Fact	W_SQR_ORDERS_F	ORDER ORDER_LINE_ITEM ORDER_LINE_ITEM_MODIFIER
Fact	W_SQR_PAYMENTS_F	PAYMENT

Data Lineage

Installation Instructions

Check dbt Hub for the latest installation instructions, or read the docs for more information on installing packages.

Include in your packages.yml

packages:
  - package: datalakehouse/dlh_square
    version: [">=0.1.0"]

Run dbt deps to install the package. Packages get installed in the dbt_packages directory – by default this directory is ignored by git, to avoid duplicating the source code for the package.

Configuration

By default, this package uses DEVELOPER_SANDBOX as the source database name and DEMO_SQUARE as schema name. If this is not the where your salesforce data is, change ther below variables configuration on your dbt_project.yml:

# dbt_project.yml

...

vars:    
    source_database: DEVELOPER_SANDBOX
    source_schema: DEMO_SQUARE
    target_schema: SQUARE

Database support

Core:

• Snowflake

Contributions

Additional contributions to this package are very welcome! Please create issues or open PRs against main. Check out this post on the best workflow for contributing to a package.

• Fork and ⭐ this repository :)
• Check it out and ⭐ the DataLakeHouse.io core repository;