# Y42 Documentation

> something amazing here

Append .md to any documentation page URL to get its markdown version.

## Guides
- [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 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)
- [Version Control with Git in Y42](https://docs.y42.com/docs/version-control-with-git-in-y42.md)
- [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)
- [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)
- [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)
- [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)
- [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)
- [What are Y42 Low-Code Models](https://docs.y42.com/docs/what-are-y42-low-code-models.md)
- [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)
- [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.
- [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)
- [What are Y42 Orchestrations](https://docs.y42.com/docs/what-are-y42-orchestrations.md)
- [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)
- [What are Status Alerts in Y42](https://docs.y42.com/docs/what-are-status-alerts-in-y42.md)
- [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.
- [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)
- [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)
- [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
- [Data Tests in Y42](https://docs.y42.com/docs/what-are-y42-data-tests.md)
- [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)
- [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)
- [Comments](https://docs.y42.com/docs/comments.md): Quick explainer of the chat functionalities in the Y42 platform
- [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)

## API 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)
- [Mixpanel](https://docs.y42.com/reference/mixpanel.md)
- [Netsuite](https://docs.y42.com/reference/netsuite.md)
- [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)
- [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)
- [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)
- [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)
- [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)
- [Text Extraction Node](https://docs.y42.com/reference/text-extraction-node-1.md)
- [Geolocation Node](https://docs.y42.com/reference/geolocation-node-1.md)
- [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)
- [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)
- [What happens in the data warehouse?](https://docs.y42.com/reference/what-happens-in-the-data-warehouse.md): Case Study of what happens in the data warehouse when users work on their low code models.
- [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)
- [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)
- [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)
- [Data tests reference](https://docs.y42.com/reference/data-tests-reference.md)
- [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)
- [API Overview](https://docs.y42.com/reference/api_overview.md)
- [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, encode url if it's needed (urlencode): 'src%2FOrchestrations%2Fmy%2C%20folder%2F%2A,src%2FOrchestrations%2Fmy%2C%20folder2%2F%2A'  <a target="_blank" href="https://api.dev.y42.dev/api/2/orchestrations/docs#/default/get_api_2_orchestrations_company__company_id_">(Internal reference)</a>
- [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>
- [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" href="https://api.dev.y42.dev/v2/trigger/apidocs/#/status/delete_company__company_id__status__identifier_">(Internal reference)</a>
- [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 `valid_only`. If the query parameter `include_parents` is set to true, the parent jobs of the requested jobs will be returned as a nested property of their child jobs if available.  <a target="_blank" href="https://api.dev.y42.dev/api/1/job-info-service/docs#/Jobs/get_api_1_job_info_service_company__company_id__latest_jobs">(Internal reference)</a>
- [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 extended to include the parent jobs  of the jobs requested where available.  <a target="_blank" href="https://api.dev.y42.dev/api/1/job-info-service/docs#/Jobs/get_api_1_job_info_service_company__company_id__jobs">(Internal reference)</a>
- [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 set, the returned job will contain its parent job as a property.  <a target="_blank" href="https://api.dev.y42.dev/api/1/job-info-service/docs#/Jobs/get_api_1_job_info_service_company__company_id__job__job_id_">(Internal reference)</a>
- [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___space_id_">(Internal reference)</a>
- [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" href="https://api.dev.y42.dev/api/1/github-backend/docs#/dwh/post_api_1_github_backend_company__company_id__dwh__space_id__setup_bigquery">(Internal reference)</a>
- [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" href="https://api.dev.y42.dev/api/1/github-backend/docs#/dwh/post_api_1_github_backend_company__company_id__dwh__space_id__setup_snowflake_azure">(Internal reference)</a>
- [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" href="https://api.dev.y42.dev/api/1/github-backend/docs#/dwh/post_api_1_github_backend_company__company_id__dwh__space_id__setup_snowflake_gcs">(Internal reference)</a>
- [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" href="https://api.dev.y42.dev/api/1/github-backend/docs#/dwh/post_api_1_github_backend_company__company_id__dwh__space_id__setup_snowflake_s3">(Internal reference)</a>
- [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___sub_path_">(Internal reference)</a>
- [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___sub_path_">(Internal reference)</a>
- [Get companies](https://docs.y42.com/reference/gateway_companies_get.md)
- [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 schemas are intended for use in git.
- [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