# Y42 Documentation

> something amazing here

## Y42 Guide: Overview
- [Welcome to Y42](https://docs.y42.com/docs/welcome.md): What is Y42 and how can it help me level up my data operations?
- [Y42 Core Concepts](https://docs.y42.com/docs/y42-core-concepts.md): How Y42 works, in a nutshell
  - [Data Assets](https://docs.y42.com/docs/data-assets.md): A quick summary of what are data assets, and how do they make a difference on how Y42 works.
  - [Asset Sidebar](https://docs.y42.com/docs/asset-sidebar.md): Here we provide a quick overview of the functionalities provided by the asset sidebar.

## Y42 Guide: Getting Started
- [Y42 Project Structure](https://docs.y42.com/docs/overview-2.md)
- [Creating a Y42 Organization](https://docs.y42.com/docs/creating-a-y42-organization.md): Here we provide a quick overview of the necessary steps to create a Y42 organization.
- [Creating a Space](https://docs.y42.com/docs/setting-up-a-y42-space.md): Here we provide a quick overview of the necessary steps to create a Y42 space.
- [Adding a space using Snowflake as a data warehouse and  Amazon S3 storage service to run imports for integrations](https://docs.y42.com/docs/adding-a-space-using-snowflake-as-a-data-warehouse-and-amazon-s3-storage-service-to-run-imports-for-integrations.md)
- [FAQs](https://docs.y42.com/docs/faqs-1.md)
  - [How to prepare Google Cloud for Y42](https://docs.y42.com/docs/how-to-prepare-google-cloud-for-y42.md)

## Y42 Guide: Git Version Control
- [Version Control with Git in Y42](https://docs.y42.com/docs/version-control-with-git-in-y42.md)

## Y42 Guide: Integrations
- Overview
  - [Integrations in Y42](https://docs.y42.com/docs/overview.md)
  - [Import Overview](https://docs.y42.com/docs/sync-overview.md): Import is the process an Integration does to extract data from a data source and load it into the designated data warehouse.
  - [Features](https://docs.y42.com/docs/features.md)
- Guides
  - [How to Import data from a Data Source](https://docs.y42.com/docs/how-to-import-a-new-data-source.md)
  - [How to Preview Your Data](https://docs.y42.com/docs/how-to-preview-your-data.md)
- Applications
  - [Google Ads Setup](https://docs.y42.com/docs/google-ads-setup.md)
  - [Netsuite Setup](https://docs.y42.com/docs/netsuite-setup.md)
- [Integration FAQs](https://docs.y42.com/docs/faqs.md)
  - [Google Ads FAQs](https://docs.y42.com/docs/google-ads-1.md)
  - [How to authenticate GA4 (Airbyte) with OAuth](https://docs.y42.com/docs/how-to-authenticate-ga4-airbyte-with-oauth.md)
  - [Google Analytics 4 (Airbyte) FAQs](https://docs.y42.com/docs/google-analytics-4-airbyte-faqs.md)
  - [Shopify FAQs](https://docs.y42.com/docs/shopify-faqs.md)
  - [MySQL FAQs](https://docs.y42.com/docs/mysql-faqs.md)
  - [UA → GA4 FAQs](https://docs.y42.com/docs/ua-ga4-faqs.md)

## Y42 Guide: SQL-Model
- Overview
  - [What are SQL Models in Y42?](https://docs.y42.com/docs/how-to-set-up-a-sql-model.md)
  - [Naming Best Practices](https://docs.y42.com/docs/naming-best-practices.md)
- Guides
  - [Create your first SQL Model](https://docs.y42.com/docs/create-your-first-sql-model.md)
  - [How to create charts out of your queries](https://docs.y42.com/docs/how-to-create-charts-out-of-your-queries.md)
  - [How to create Data Tests for your Output Tables](https://docs.y42.com/docs/create-data-tests-for-your-tables.md)
  - [How to create a Data Pipeline fast](https://docs.y42.com/docs/how-to-create-a-data-pipeline-fast.md)
  - [How to use Jinja Templating](https://docs.y42.com/docs/how-to-use-jinja.md)
  - [How to use Macros in a SQL Query](https://docs.y42.com/docs/how-to-use-macros-in-a-sql-query.md)
  - [How to create an incremental Model](https://docs.y42.com/docs/create-your-first-incremental-model.md)
  - [How to learn SQL fast](https://docs.y42.com/docs/how-to-learn-sql-fast.md)
  - [How to use Keyboard Shortcuts in SQL Model](https://docs.y42.com/docs/how-to-use-keyboard-shortcuts-in-sql-model.md)

## Y42 Guide: Low-Code Model
- Overview
  - [What are Y42 Low-Code Models](https://docs.y42.com/docs/what-are-y42-low-code-models.md)
- Guides
  - [Create your first Low-Code Model](https://docs.y42.com/docs/create-your-first-model.md)
- [Low-Code Model FAQs](https://docs.y42.com/docs/low-code-model-faqs.md)

## Y42 Guide: Visualizations
- Overview
  - [What are Y42 Visualizations?](https://docs.y42.com/docs/what-are-y42-visualizations.md): A short introduction to what you can expect from the Y42 Visualizations product.
- Guides
  - [How to work with Dashboards](https://docs.y42.com/docs/how-to-work-with-dashboards.md): Here we give a quick guide on how to set up your first Dashboard. For the full details on all Dashboard, Dashboard Tab and Canvas settings, see the Visualizations Reference Documentation.
  - [How to work with Widgets](https://docs.y42.com/docs/how-to-work-with-widgets.md): Here we give a quick guide on how to set up your first widget. For the full details on all widget settings, see the Visualizations Reference Documentation.
  - [How to work with Calculated Fields](https://docs.y42.com/docs/how-to-work-with-calculated-fields.md): Calculated Fields allow users to create metrics for visualizations on the fly. With Calculated Fields, there is no need to go back to the modeling layer to get a ratio or perform small changes.
  - [Create a Simple Chart (Bar/ Line/ Area)](https://docs.y42.com/docs/creating-a-simple-chart-bar-line-area.md)
  - [Create a Scatter Plot](https://docs.y42.com/docs/create-a-scatter-plot.md)
  - [Create a Number Box](https://docs.y42.com/docs/create-a-number-box.md)
  - [Create a Pie Chart](https://docs.y42.com/docs/create-a-pie-chart.md)
  - [Create a Treemap](https://docs.y42.com/docs/create-a-treemap.md)
  - [Create a Table or Pivot Table](https://docs.y42.com/docs/create-a-table-or-pivot-table.md)
  - [How to work with Date Filters](https://docs.y42.com/docs/use-date-filters-in-visualizations.md)
  - [How to connect Y42 to Google Data Studio, Tableau, Power BI & Looker](https://docs.y42.com/docs/how-to-connect-y42-to-google-data-studio-tableau-power-bi-looker.md)
  - [How to customize a chart widget using Y42 as code](https://docs.y42.com/docs/how-to-customize-a-chart-widget-using-y42-as-code.md)
- [Visualization FAQs](https://docs.y42.com/docs/visualization-faqs.md)

## Y42 Guide: Orchestration
- Overview
  - [What are Y42 Orchestrations](https://docs.y42.com/docs/what-are-y42-orchestrations.md)
- Guides
  - [How to set up an Orchestration](https://docs.y42.com/docs/how-to-set-up-an-orchestration.md)
  - [How to set up a schedule & use the Run Configs](https://docs.y42.com/docs/how-to-set-up-a-schedule-use-the-run-configs.md)
- [Orchestration FAQs](https://docs.y42.com/docs/orchestration-faqs.md)

## Y42 Guide: Alerts
- Overview
  - [What are Status Alerts in Y42](https://docs.y42.com/docs/what-are-status-alerts-in-y42.md)
- Guides
  - [How to create an Alert](https://docs.y42.com/docs/how-to-create-an-alert.md)
  - [How to use Patterns & Tags effectively](https://docs.y42.com/docs/how-to-use-patterns-tags-effectively.md)
  - [Webhooks](https://docs.y42.com/docs/webhooks-1.md): Learn the basics of how webhooks work to help you build and set up one.

## Y42 Guide: Data Exports
- Overview
  - [What is a Data Export?](https://docs.y42.com/docs/what-is-a-data-export.md)
  - [How to set up Data Exports](https://docs.y42.com/docs/how-to-set-up-data-exports.md)
- Authentication
  - [Google Sheets](https://docs.y42.com/docs/google-sheets.md)
  - [Amazon S3](https://docs.y42.com/docs/amazon-s3.md)
  - [Google Big Query](https://docs.y42.com/docs/google-big-query.md)

## Y42 Guide: Data Lineage
- [Introduction to data lineage](https://docs.y42.com/docs/what-is-the-y42-data-lineage.md): Overview of the goals and capabilities of data lineage in Y42

## Y42 Guide: Data Tests
- [Data Tests in Y42](https://docs.y42.com/docs/what-are-y42-data-tests.md)
- Guides
  - [How to set up Data Tests for Output Tables](https://docs.y42.com/docs/how-to-set-up-data-tests-for-output-tables.md)
- [Data Tests FAQs](https://docs.y42.com/docs/data-test-faqs.md)

## Y42 Guide: Access Control
- [Access Control in Y42](https://docs.y42.com/docs/access-control-in-y42.md)
- [Access Control FAQs](https://docs.y42.com/docs/access-control-faqs.md)

## Y42 Guide: Other Functionality
- [Comments](https://docs.y42.com/docs/comments.md): Quick explainer of the chat functionalities in the Y42 platform
- SSO Setup
  - [Setting Up SSO with SAML](https://docs.y42.com/docs/okta-saml-setup.md): You can use SAML protocol to integrate your identity provider like Okta with Y42 platform.
  - [Setting Up SSO with OAuth](https://docs.y42.com/docs/oauth-integration.md): You can use OAuth protocol to integrate your identity provider like Okta with Y42 platform.
  - [Setting Up SSO with Okta](https://docs.y42.com/docs/setting-up-sso-with-okta.md)

## Reference: Integrations Reference
- [Integrations Menu Overview](https://docs.y42.com/reference/integrations-reference.md)
  - [Table Set-up](https://docs.y42.com/reference/table-set-up.md)
  - [Data](https://docs.y42.com/reference/data.md)
  - [Job Overview](https://docs.y42.com/reference/job-overview-1.md)
- Applications
  - [Mixpanel](https://docs.y42.com/reference/mixpanel.md)
  - [Netsuite](https://docs.y42.com/reference/netsuite.md)

## Reference: Visualizations Reference
- [Dashboard Settings](https://docs.y42.com/reference/dashboard-settings.md)
- [Tab Settings](https://docs.y42.com/reference/tab-settings.md)
- [Canvas Functionality](https://docs.y42.com/reference/canvas-functionality.md)
- Widget Editor
  - [Selecting Fields](https://docs.y42.com/reference/selecting-fields.md)
  - [Field Settings](https://docs.y42.com/reference/field-settings.md)
  - [Chart Settings](https://docs.y42.com/reference/chart-settings.md)
  - [Conditional/ Color formatting](https://docs.y42.com/reference/conditional-color-formatting.md)
  - [Navigation](https://docs.y42.com/reference/navigation.md)

## Reference: Low-Code Models Reference
- [What is UI-Model in Y42?](https://docs.y42.com/reference/what-is-ui-model-in-y42-1.md)
- [UI Model Reference Documentation](https://docs.y42.com/reference/ui-model-reference-documentation.md)
- [Canvas: Collaboration Tools](https://docs.y42.com/reference/canvas-collaboration-tools-1.md)
- [UI-Model Menu Overview](https://docs.y42.com/reference/ui-models-menu-overview.md)
  - [UI Model: Jobs Tab](https://docs.y42.com/reference/ui-model-overview-tab-1.md)
  - [UI Model: Structure Tab](https://docs.y42.com/reference/ui-model-structure-tab-1.md)
  - [UI Model: Data Tab](https://docs.y42.com/reference/ui-model-data-tab-1.md)
- Table Manipulations
  - [Input Node](https://docs.y42.com/reference/input-node-1.md)
  - [Output Node](https://docs.y42.com/reference/output-node-1.md)
  - [Union Node](https://docs.y42.com/reference/union-node-1.md)
  - [Join Node](https://docs.y42.com/reference/join-node-1.md)
  - [Partition Node](https://docs.y42.com/reference/partition-node.md)
  - [Aggregations Node](https://docs.y42.com/reference/aggregations-node-2.md)
- Column Manipulations
  - [Functions Node](https://docs.y42.com/reference/functions-node-1.md)
  - [Case Node](https://docs.y42.com/reference/case-node-1.md)
  - [Fields Node](https://docs.y42.com/reference/fields-node-1.md)
  - [Replace Node](https://docs.y42.com/reference/replace-node-1.md)
  - [JSON Extraction Node](https://docs.y42.com/reference/json-extraction-node.md)
  - [Bin Node](https://docs.y42.com/reference/bin-node-1.md)
  - [Coalesce Node](https://docs.y42.com/reference/coalesce-node-1.md)
  - [Unpivot Node](https://docs.y42.com/reference/unpivot-node.md)
  - [Pivot Node](https://docs.y42.com/reference/pivot-node-1.md)
  - [Fill Node](https://docs.y42.com/reference/fill-node-1.md)
- Strings
  - [Text Extraction Node](https://docs.y42.com/reference/text-extraction-node-1.md)
- Geolocations
  - [Geolocation Node](https://docs.y42.com/reference/geolocation-node-1.md)
- Datetime
  - [Date Comparison Node](https://docs.y42.com/reference/date-comparison-node-1.md)
  - [Date Parser Node](https://docs.y42.com/reference/date-parser-node-1.md)
  - [Date Formatter Node](https://docs.y42.com/reference/date-formatter-node-1.md)
  - [Date Manipulation Node](https://docs.y42.com/reference/date-manipulation-node.md)
- Row Manipulations
  - [Advanced Filter Node](https://docs.y42.com/reference/advanced-node-filter.md)
  - [Filter Node](https://docs.y42.com/reference/filter-node-1.md)
  - [Sort Node](https://docs.y42.com/reference/sort-node-1.md)
  - [Remove Duplicate Rows Node](https://docs.y42.com/reference/remove-duplicate-rows-node-1.md)

## Reference: SQL-Models Reference
- [Job-Overview](https://docs.y42.com/reference/job-overview.md)
- [Table Set-Up](https://docs.y42.com/reference/sql-models-structure-section.md)
  - [Table Explorer](https://docs.y42.com/reference/table-explorer.md)
  - [View History](https://docs.y42.com/reference/table-explorer-1.md)
  - [Editor Commands](https://docs.y42.com/reference/editor-commands.md)
  - [Keyboard Shortcuts SQL](https://docs.y42.com/reference/keyboard-shortcuts-sql.md)
  - [Incremental Model Update](https://docs.y42.com/reference/incremental-model-update.md)
  - [Functions in Snowflake](https://docs.y42.com/reference/functions-in-snowflake.md)
  - [Functions in BigQuery](https://docs.y42.com/reference/functions-in-bigquery.md)
  - [Jinja & Macros](https://docs.y42.com/reference/jinja-macros.md)
  - [BigQuery: Partitioning & Clustering](https://docs.y42.com/reference/bigquery-partitioning-clustering.md)
- [Data Section](https://docs.y42.com/reference/data-section.md)
- [SQL Model Reference](https://docs.y42.com/reference/sql-model-reference.md)
- [Naming in Y42](https://docs.y42.com/reference/naming-in-y42.md)

## Reference: Alerts Reference
- [Status Alert's Overview Section](https://docs.y42.com/reference/status-alerts-structure-section.md)
- [Status Alerts Reference](https://docs.y42.com/reference/status-alerts-reference.md)

## Reference: Orchestrations Reference
- [Orchestration Reference](https://docs.y42.com/reference/orchestration-reference.md)
- [Orchestration Setup Section](https://docs.y42.com/reference/orchestrations-structure-section.md)
- [Orchestration's Jobs Section](https://docs.y42.com/reference/orchestrations-overview-menu.md)
- [Bottom Drawer](https://docs.y42.com/reference/bottom-drawer.md)

## Reference: Data Tests Reference
- [Data tests reference](https://docs.y42.com/reference/data-tests-reference.md)

## Reference: Data Exports Reference
- [Data Exports Reference](https://docs.y42.com/reference/data-exports-reference.md)
- [Data Exports Overview Menu](https://docs.y42.com/reference/data-exports-overview-menu.md)

## Reference: Public API
- [API Overview](https://docs.y42.com/reference/api_overview.md)
- Orchestration runs
  - [Get orchestrations runs](https://docs.y42.com/reference/gateway_companies__company_id__orchestration_runs_get.md): Set x-storage-location header to fetch orchestration file(s):  1) a comma separated list: 'src/Orchestrations/alpha/*,src/Orchestrations/beta/*'  2) string: 'src/Orchestrations/alpha/*'  3) string,…
  - [Trigger orchestration run](https://docs.y42.com/reference/gateway_companies__company_id__orchestration_runs_post.md): <a target="_blank" href="https://api.dev.y42.dev/api/2/orchestrations/docs#/default/post_api_2_orchestrations_company__company_id_">(Internal reference)</a>
  - [Get one orchestration run](https://docs.y42.com/reference/gateway_companies__company_id__orchestration_runs__run_id__get.md): <a target="_blank" href="https://api.dev.y42.dev/api/2/orchestrations/docs#/default/get_api_2_orchestrations_company__company_id___run_id_">(Internal reference)</a>
  - [Stop orchestrations run](https://docs.y42.com/reference/gateway_companies__company_id__orchestration_runs__run_id__stop_post.md): <a target="_blank" href="https://api.dev.y42.dev/api/2/orchestrations/docs#/default/post_api_2_orchestrations_company__company_id___run_id__stop">(Internal reference)</a>
- Jobs
  - [Trigger model or integration job](https://docs.y42.com/reference/gateway_companies__company_id__jobs_trigger_post.md): <a target="_blank" href="https://api.dev.y42.dev/v2/trigger/apidocs/#/task/post_company__company_id__task">(Internal reference)</a>
  - [Get status of running job](https://docs.y42.com/reference/gateway_companies__company_id__jobs_trigger__identifier__get.md): <a target="_blank" href="https://api.dev.y42.dev/v2/trigger/apidocs/#/status/get_company__company_id__status__identifier_">(Internal reference)</a>
  - [Cancel model or integration job](https://docs.y42.com/reference/gateway_companies__company_id__jobs_trigger__identifier__delete.md): <p>Tries to stop a running task. It will only get marked as &quot;stopped&quot;, depending on the step the given task is at, it might not yet get picked up, but still finish</p>   <a target="_blank"…
  - [Get last valid job for model or integration](https://docs.y42.com/reference/gateway_companies__company_id__jobs_latest_get.md): Retrieves the latest job for each asset (path) matching the storage parameters. Can either load just the latest for each asset, or only jobs in state ready, depending on the query parameter…
  - [Get full job history for model or integration](https://docs.y42.com/reference/gateway_companies__company_id__jobs_get.md): Retrieves all jobs for all assets (paths) matching the storage parameters, ordered by their `created_at` time. If the query parameter `include_parents` is set, the array of jobs returned will be…
  - [Get one job](https://docs.y42.com/reference/gateway_companies__company_id__jobs__job_id__get.md): Retrieves single job. The job will only be returned if the specified space_id and company_id are matching the requested job_id, ignoring path and branch. If the query parameter `include_parent` is…
- Spaces
  - [List spaces](https://docs.y42.com/reference/gateway_companies__company_id__spaces__get.md): <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/space/get_api_1_github_backend_company__company_id__">(Internal reference)</a>
  - [Create Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces_new_post.md): <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/space/post_api_1_github_backend_company__company_id__gitlab_setup_space">(Internal reference)</a>
  - [Get space details](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__get.md): <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/space/get_api_1_github_backend_company__company_id___space_id_">(Internal reference)</a>
  - [Delete Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__delete.md): <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/space/delete_api_1_github_backend_company__company_id___space_id_">(Internal reference)</a>
  - [Update Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__patch.md): - rename the space - set it as default - set job retention time  <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/space/patch_api_1_github_backend_company__company_id___spac…
  - [Setup BigQuery in Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__setup_bigquery_post.md): Using provided service account we create/update dwh details based on the 'update' query parameter  <a target="_blank"…
  - [Setup Snowflake with Azure Blob Storage in Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__setup_snowflake_azure_post.md): azure container creds and create/update dwh details based on the 'update' query parameter then create new secret  <a target="_blank"…
  - [Setup Snowflake with GCS in Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__setup_gcs_post.md): Using provided snowflake creds, google service account we can create/update dwh details based on the 'update' query parameter then create new secret  <a target="_blank"…
  - [Setup Snowflake with AWS S3 in Space](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__setup_s3_post.md): Using provided snowflake creds,s3 bucket creds we can create/update dwh details based on the  'update' query parameter then create new secret  <a target="_blank"…
  - [Git Proxy](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__git__sub_path__get.md): Git extra header needed with auth token while cloning.  <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/proxy/get_api_1_github_backend_company__company_id__clone__space_id_…
  - [Git Proxy](https://docs.y42.com/reference/gateway_companies__company_id__spaces__space_id__git__sub_path__post.md): Git extra header needed with auth token while cloning.  <a target="_blank" href="https://api.dev.y42.dev/api/1/github-backend/docs#/proxy/post_api_1_github_backend_company__company_id__clone__space_id…
- Companies
  - [Get companies](https://docs.y42.com/reference/gateway_companies_get.md)
- Integration
  - [Authenticate integration](https://docs.y42.com/reference/gateway_companies__company_id__secret_post.md): See routes in Integration types getting the schemas of the secret required for each integration (i.e. the precise schema of the `secret` field required in the request body). The source and table…
- Integration types
  - [Get all available integration types](https://docs.y42.com/reference/gateway_integration_types_get.md): Lists all available integration types (connectors).
  - [Get integration secret schema](https://docs.y42.com/reference/gateway_integration_types__integration_name__secret_schemajson_get.md): Get the schema of the `secret` in the body required for authenticating the integration
  - [Get integration table schema](https://docs.y42.com/reference/gateway_integration_types__integration_name__table_schemajson_get.md): Get the schema of the settings.json file for each table (subfolder) of the integration
  - [Get integration source schema](https://docs.y42.com/reference/gateway_integration_types__integration_name__source_schemajson_get.md): Get the schema of the main settings.json file for the integration