Merge branch 'current' into Tonayya-patch-1

taraojo · Apr 21, 2023 · aba4c4f · aba4c4f
2 parents 61c1d69 + 7ec09ce
commit aba4c4f
Show file tree

Hide file tree

Showing 17 changed files with 731 additions and 13 deletions.
diff --git a/website/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt.md b/website/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt.md
diff --git a/website/blog/authors.yml b/website/blog/authors.yml
@@ -478,3 +478,13 @@ yu_ishikawa:
       url: https://www.linkedin.com/in/yuishikawa0301
   name: Yu Ishikawa
   organization: Ubie
+
+jonathan_neo:
+  image_url: /img/blog/authors/jonathan-neo.png
+  job_title: Data Engineer
+  links:
+    - icon: fa-linkedin
+      url: https://www.linkedin.com/in/jonneo/
+  name: Jonathan Neo
+  organization: Canva & Data Engineer Camp
+  description: Jonathan is a Data Engineer at Canva where he is building and maintaining petabyte-scale data platforms. Jonathan founded Data Engineer Camp, a bootcamp that empowers professionals to become proficient data engineers. He has since trained data and software professionals from around that are working at companies like Microsoft, Atlassian, and Apple. 
diff --git a/website/docs/docs/cloud/connect-data-platform/connect-starburst-trino.md b/website/docs/docs/cloud/connect-data-platform/connect-starburst-trino.md
@@ -1,21 +1,21 @@
 ---
-title: "Connect Starburst/Trino"
-description: "Configure Starburst/Trino connection."
-sidebar_label: "Connect Starburst/Trino"
+title: "Connect Starburst or Trino"
+description: "Configure Starburst or Trino connection."
+sidebar_label: "Connect Starburst or Trino"
 ---
 
-The following are the required fields for setting up a connection with Starburst Enterprise, Starburst Galaxy, and Trino cluster. Unless specified, "cluster" will mean any of these products' clusters.     
+The following are the required fields for setting up a connection with a [Starburst Enterprise](https://docs.starburst.io/starburst-enterprise/index.html), [Starburst Galaxy](https://docs.starburst.io/starburst-galaxy/index.html), or [Trino](https://trino.io/) cluster. Unless specified, "cluster" means any of these products' clusters.
 
 | Field | Description | Examples |
 | --- | --- | --- |
 | **Host** | The hostname of your cluster. Don't include the HTTP protocol prefix. | `mycluster.mydomain.com` |
 | **Port** | The port to connect to your cluster. By default, it's 443 for TLS enabled clusters. | `443` |
-| **User** | The username (of the account) to log in to your cluster. When connecting to Starburst Galaxy clusters, you must include the role of the user as a suffix to the username.<br/><br/> | Format for Starburst Enterprise or Trino: <br/> <ul><li>`user.name`</li><li>`[email protected]`</li></ul><br/>Format for Starburst Galaxy:<br/> <ul><li>`[email protected]/role`</li></ul> |
+| **User** | The username (of the account) to log in to your cluster. When connecting to Starburst Galaxy clusters, you must include the role of the user as a suffix to the username.<br/><br/> | Format for Starburst Enterprise or Trino depends on your configured authentication method. <br/>Format for Starburst Galaxy:<br/> <ul><li>`[email protected]/role`</li></ul> |
 | **Password** | The user's password. |   |
-| **Database** | The name of a catalog in your cluster. | `my_postgres_catalog` |
-| **Schema** | The name of a schema in your cluster that exists within the specified catalog.  | `my_schema` |
+| **Database** | The name of a catalog in your cluster. | `example_catalog` |
+| **Schema** | The name of a schema that exists within the specified catalog.  | `example_schema` |
 
-## Roles in Starburst Enterprise 
+## Roles in Starburst Enterprise
 
 <Snippet src="connect-starburst-trino/roles-starburst-enterprise" />
 

diff --git a/website/docs/docs/quickstarts/dbt-cloud/starburst-galaxy-qs.md b/website/docs/docs/quickstarts/dbt-cloud/starburst-galaxy-qs.md
@@ -5,9 +5,9 @@ id: "starburst-galaxy"
 sidebar_label: "Starburst Galaxy quickstart"
 ---
 
-In this quickstart guide, you'll learn how to use dbt Cloud with [Starburst Galaxy](https://www.starburst.io/). It will show you how to:
+In this quickstart guide, you'll learn how to use dbt Cloud with [Starburst Galaxy](https://www.starburst.io/platform/starburst-galaxy/). It will show you how to:
 
-- Load data into the Amazon S3 bucket. This guide uses AWS as the cloud service provider for demonstrative purposes. Starburst Galaxy also [supports other providers](https://www.starburst.io/platform/connectors/) such as Google Cloud, Microsoft Azure, and more. 
+- Load data into the Amazon S3 bucket. This guide uses AWS as the cloud service provider for demonstrative purposes. Starburst Galaxy also [supports other data sources](https://docs.starburst.io/starburst-galaxy/catalogs/index.html) such as Google Cloud, Microsoft Azure, and more.
 - Connect Starburst Galaxy to the Amazon S3 bucket.
 - Create tables with Starburst Galaxy.
 - Connect dbt Cloud to Starburst Galaxy.
@@ -398,12 +398,12 @@ Later, you can connect your business intelligence (BI) tools to these views and
 ## Connect to multiple data sources
 This quickstart focuses on using dbt Cloud to run models against a data lake (S3) by using Starburst Galaxy as the query engine. In most real world scenarios, the data that is needed for running models is actually spread across multiple data sources and is stored in a variety of formats. With Starburst Galaxy, Starburst Enterprise, and Trino, you can run your models on any of the data you need, no matter where it is stored.
 
-If you want to try this out, you can use the [Starburst Galaxy docs](https://docs.starburst.io/starburst-galaxy/catalogs/) to add more data sources and load the Jaffle Shop data into the source you select. Then, extend your models to query the new data source and the data source you created in this quickstart. 
+If you want to try this out, you can refer to the [Starburst Galaxy docs](https://docs.starburst.io/starburst-galaxy/catalogs/) to add more data sources and load the Jaffle Shop data into the source you select. Then, extend your models to query the new data source and the data source you created in this quickstart.
 
 ## Related content
 - Learn more with the [dbt Fundamentals](https://courses.getdbt.com/courses/fundamentals) course for free
 - [dbt Courses](https://courses.getdbt.com/collections)
 - [dbt Cloud CI job](/docs/deploy/cloud-ci-job)
 - [Job notifications](/docs/deploy/job-notifications)
 - [Source freshness](/docs/deploy/source-freshness)
-- [SQL basics for Starburst Galaxy](https://docs.starburst.io/starburst-galaxy/tutorials/learn-basics.html)
+- [SQL overview for Starburst Galaxy](https://docs.starburst.io/starburst-galaxy/sql/index.html)
diff --git a/website/snippets/connect-starburst-trino/roles-starburst-enterprise.md b/website/snippets/connect-starburst-trino/roles-starburst-enterprise.md
@@ -1,3 +1,3 @@
 [comment: For context, the section title used for this snippet is "Roles in Starburst Enterprise" ]: # 
 
-When connecting to a Starburst Enterprise cluster with built-in access controls enabled, you won't be able to provide the role as a suffix to the username, so the default role for the provided username will be used instead.
+If connecting to a Starburst Enterprise cluster with built-in access controls enabled, you can't add the role as a suffix to the username, so the default role for the provided username is used instead.
diff --git a/...4-18-building-a-kimball-dimensional-model-with-dbt/3nf-to-dimensional-model.png b/...4-18-building-a-kimball-dimensional-model-with-dbt/3nf-to-dimensional-model.png
diff --git a/.../blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/conversation.png b/.../blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/conversation.png
diff --git a/...log/2023-04-18-building-a-kimball-dimensional-model-with-dbt/data-modelling.png b/...log/2023-04-18-building-a-kimball-dimensional-model-with-dbt/data-modelling.png
diff --git a/...c/img/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/dbt-dag.png b/...c/img/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/dbt-dag.png
diff --git a/...g/2023-04-18-building-a-kimball-dimensional-model-with-dbt/dimension-tables.png b/...g/2023-04-18-building-a-kimball-dimensional-model-with-dbt/dimension-tables.png
diff --git a/...img/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/fct_sales.png b/...img/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/fct_sales.png
diff --git a/...-18-building-a-kimball-dimensional-model-with-dbt/sales-order-header-detail.png b/...-18-building-a-kimball-dimensional-model-with-dbt/sales-order-header-detail.png
diff --git a/...g/2023-04-18-building-a-kimball-dimensional-model-with-dbt/snowflake-schema.png b/...g/2023-04-18-building-a-kimball-dimensional-model-with-dbt/snowflake-schema.png
diff --git a/...blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/source-schema.png b/...blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/source-schema.png
diff --git a/...g/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/star-schema.png b/...g/blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/star-schema.png
diff --git a/...blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/target-schema.png b/...blog/2023-04-18-building-a-kimball-dimensional-model-with-dbt/target-schema.png
diff --git a/website/static/img/blog/authors/jonathan-neo.png b/website/static/img/blog/authors/jonathan-neo.png