Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples
Focus: Master the development workflows for different types of data applications, from dbt transformations to Python scripts and interactive Streamlit dashboards.The 5X IDE provides specialized development environments for the most common data development tasks. This guide covers practical workflows for building data models, applications, and dashboards with real examples and best practices.
Development EnvironmentThe IDE comes pre-configured with multiple Python versions, dbt environments, and development tools. No additional setup required for basic development tasks.
Python development
Python environment overview
The IDE comes pre-installed with multiple Python versions managed through pyenv, providing flexibility for different project requirements and dependency compatibility.Available Python versions:
Python 3.8.20 - Extended legacy support for older projects
Python 3.9.23 - Legacy support for older projects
Python 3.10.18 - Stable version with good package compatibility
Python 3.11.13 - Default version (set by PYENV_VERSION)
Python 3.12.11 - Latest stable with performance improvements
Python 3.13.4 - Cutting-edge features and optimizations
View installed versions:
ls /root/.pyenv/versions
Virtual environment management
Python virtual environments provide isolated dependency management for your projects, preventing conflicts between different project requirements.Create a virtual environment:
# Using Python 3.11.13 (default)/root/.pyenv/versions/3.11.13/bin/python -m venv my_project_env# Using specific Python version/root/.pyenv/versions/3.10.18/bin/python -m venv legacy_project_env
Activate and manage environments:
# Activate environmentsource my_project_env/bin/activate# Verify active environment (should show your env path)which python# Deactivate when finisheddeactivate
Dependency management best practices
Maintain project dependencies using requirements.txt files for reproducible environments across team members and deployment targets.Create requirements.txt:
# Core data processingpandas==2.0.3numpy==1.24.3# API and web requests requests==2.31.0urllib3==2.0.4# Visualizationmatplotlib==3.7.2seaborn==0.12.2# Development toolsjupyter==1.0.0pytest==7.4.0
import pandas as pdimport numpy as npfrom sqlalchemy import create_enginedef process_customer_data(connection_string): """Process customer data from warehouse""" engine = create_engine(connection_string) # Load data df = pd.read_sql("SELECT * FROM customers", engine) # Data transformations df['full_name'] = df['first_name'] + ' ' + df['last_name'] df['customer_tier'] = pd.cut(df['total_spent'], bins=[0, 100, 500, 1000, float('inf')], labels=['Bronze', 'Silver', 'Gold', 'Platinum']) # Save processed data df.to_sql('processed_customers', engine, if_exists='replace', index=False) return dfif __name__ == "__main__": # Your connection string here conn_str = "your_connection_string" result = process_customer_data(conn_str) print(f"Processed {len(result)} customers")
API integration example:
import requestsimport jsonfrom datetime import datetimeclass DataAPI: def __init__(self, base_url, api_key): self.base_url = base_url self.headers = {'Authorization': f'Bearer {api_key}'} def fetch_data(self, endpoint, params=None): """Fetch data from API endpoint""" response = requests.get( f"{self.base_url}/{endpoint}", headers=self.headers, params=params ) response.raise_for_status() return response.json() def process_and_save(self, endpoint, db_connection): """Fetch, process, and save data to database""" data = self.fetch_data(endpoint) # Process data df = pd.DataFrame(data) df['processed_at'] = datetime.now() # Save to database df.to_sql('api_data', db_connection, if_exists='append', index=False) return df
dbt development
dbt Power User extension (recommended approach)
The dbt Power User extension provides the most integrated development experience, automatically using your configured dbt settings from Settings → Credentials including version selection, database connections, and target configuration.Key workflows:
Model execution
Run and test modelsExecute individual models, selections, or entire dbt projects with integrated test runner
Lineage visualization
Understand dependenciesInteractive dependency graphs showing upstream and downstream model relationships
Documentation
Generate docsCreate and view dbt documentation with integrated preview and automatic refresh
SQL compilation
Preview compiled SQLSee the actual SQL that will be executed before running models
Command-line dbt development
For users preferring terminal-based workflows, the IDE provides pre-configured dbt virtual environments for each supported version.Activate dbt environment:
# List available dbt environmentsls /root/.venv# Activate specific dbt versionsource /root/.venv/dbt-1.8.9/bin/activate# Verify dbt installationdbt --version
Available dbt versions:
dbt-1.6.18 (/root/.venv/dbt-1.6.18/) - Legacy support
dbt-1.7.19 (/root/.venv/dbt-1.7.19/) - Stable version
dbt-1.8.9 (/root/.venv/dbt-1.8.9/) - Current stable
dbt-1.9.10 (/root/.venv/dbt-1.9.10/) - Latest features
dbt development workflow
Common dbt commands:
# Navigate to your dbt project directorycd /path/to/your/dbt/project# Run entire projectdbt run# Run specific modelsdbt run --select staging.stg_customers+# Test your modelsdbt test# Generate documentationdbt docs generatedbt docs serve
Model development example:
-- models/staging/stg_customers.sqlSELECT customer_id::int AS customer_id, LOWER(TRIM(email)) AS email, INITCAP(first_name) AS first_name, INITCAP(last_name) AS last_name, created_at::timestamp AS created_at, CASE WHEN status = 'A' THEN 'active' WHEN status = 'I' THEN 'inactive' ELSE 'unknown' END AS statusFROM {{ source('crm', 'customers') }}WHERE customer_id IS NOT NULL
The IDE provides powerful lineage visualization capabilities that help you understand data flow and model dependencies throughout your dbt project.To view lineage:
Open any dbt model file in the editor
Navigate to the Lineage tab in the IDE interface
Explore interactive dependency graphs showing:
Upstream models and sources feeding into current model
Downstream models consuming current model output
Cross-project dependencies and external table references
Lineage features:
Interactive navigation - Click nodes to jump between related models
Dependency depth control - Adjust how many levels of dependencies to display
Impact analysis - Understand which models will be affected by changes
Visual debugging - Identify circular dependencies and optimization opportunities
Running dbt commands
Execute dbt commands directly from the IDE for any valid dbt project without leaving your development workspace.To run dbt commands:
1
Open dbt project
Open a dbt project folder in the IDE
2
Access dbt command interface
Click on the icon from the top-right status bar
3
Go to terminal and activate dbt environment
# List available dbt environmentsls /root/.venv# Activate specific dbt versionsource /root/.venv/dbt-1.8.9/bin/activate# Verify dbt installationdbt --version
4
Enter command
A command input box will appear, allowing you to enter the desired dbt command
5
Execute command
Confirm the command to execute it in the terminal
Terminal session management:If similar commands were executed previously for the same project, the IDE will prompt you to either:
Open a new terminal session - Start a fresh terminal for the command
Continue using existing terminal - Reuse the current terminal session
This integrated feature simplifies the dbt workflow, enabling you to build, test, and manage transformations without leaving your development workspace.Example dbt commands:
# Run all modelsdbt run# Run specific modelsdbt run --select staging.stg_customers+# Test modelsdbt test# Generate documentationdbt docs generate# Compile modelsdbt compile
Cube development
Cube creation
Create new cubes directly from the IDE without leaving your development environment, providing a seamless and integrated experience for managing cube creation.To create a cube:
1
Open cubes repository
Open any file within the cubes repository
2
Access cube creation
Click on the icon located on the top-right corner of the status bar
3
Automatic server start
The Cube Server will automatically start, enabling the cube creation process
4
Select schema
A new file tab will open, displaying a list of available schemas. Select the desired schema
5
Define and create
Proceed to define and create cubes as needed
This workflow provides a seamless and integrated experience for managing cube creation within the IDE, eliminating the need to switch between different tools or environments.
Cube server start
Start the Cube Server for a specific active file tab directly from the IDE toolbar, giving you full control over active Cube Server sessions.To start the Cube Server:
1
Open cube file
Open any file within your cubes repository
2
Start server
Click on the icon from the IDE toolbar
3
Access server
Once initiated, the Cube Server will launch and can be accessed locally via http://localhost:4000
Server conflict management:If there is an existing Cube Server instance running, a prompt will appear asking you to:
Stop the currently active server and start a new one - Terminate the existing instance and launch a fresh server
Cancel to retain the current session - Keep the existing server running
This ensures that multiple servers do not conflict and that you retain full control over active Cube Server sessions.
Running Streamlit applications and Python files
Running Streamlit applications
Run Streamlit applications directly from the IDE with automatic environment setup and dependency management.To run a Streamlit application:
1
Open Streamlit file
Open the streamlit_app.py file from the Streamlit repository
2
Run application
Click on the icon in the IDE toolbar
3
Select Python version
The IDE will prompt you to select the desired Python version for execution
4
Automatic setup
Upon confirmation, a virtual environment will be created automatically
5
Install dependencies
All dependencies listed in the requirements.txt file will be installed within the environment
6
Launch application
Once setup is complete, the Streamlit application will launch successfully
Running Python files
Execute standalone Python scripts with the same streamlined workflow as Streamlit applications.To run a Python file:
1
Open Python file
Open any Python file (.py) in the IDE
2
Run script
Click on the icon in the IDE toolbar
3
Select Python version
Choose the desired Python version for execution
4
Environment setup
A virtual environment will be created automatically if needed
5
Install dependencies
Dependencies from requirements.txt will be installed automatically
6
Execute script
The Python file will run successfully with output displayed in the terminal
Dependency management - Automatic installation of dependencies from requirements.txt reduces manual setup overhead
Version selection - Choose the appropriate Python version for your project requirements
Seamless workflow - Run applications and scripts without leaving the IDE or switching contexts
This process ensures environment consistency and reduces manual setup overhead for Streamlit or Python-based workflows, allowing you to focus on development rather than environment configuration.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"5X Documentation","colors":{"primary":"#2D2D2D","light":"#6B7280","dark":"#1F2937"},"logo":{"light":"https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/logo/light.svg?fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=eefffb90a08eb6221be43529248d5180","dark":"https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/logo/dark.svg?fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=9cb3c45e52ba7e07514f9abba45b0a0b"},"favicon":"/favicon.ico","navbar":{"links":[{"label":"Support","href":"mailto:support@5x.co"}],"primary":{"type":"button","label":"Platform","href":"https://platform.5x.co"}},"footer":{"socials":{"linkedin":"https://linkedin.com/company/datawith5x"}},"navigation":{"global":{"anchors":[{"anchor":"Blog","icon":"newspaper","href":"https://www.5x.co/blogs"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"5x","hasAudioNarration":false,"actualSubdomain":"5x","customDomains":["docs.5x.co"],"gitSource":{"type":"github","owner":"5x-platform","repo":"5x-platform-documentation","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6ae9267e8577037531044faa:success","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"default","tag":"Guides","count":41},{"language":"default","tag":"Core Features","count":33},{"language":"default","tag":"Get Started","count":8},{"language":"default","tag":"Metrics Store","count":7},{"language":"default","tag":"Quickstart Guide","count":7},{"language":"default","tag":"Business Intelligence","count":6},{"language":"default","tag":"IDE","count":5},{"language":"default","tag":"Ingestion","count":4},{"language":"default","tag":"Jobs","count":4},{"language":"default","tag":"Conversational AI","count":3}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[]}
{"page":{"pagePath":"core-features/ide/development-workflows","slug":"/core-features/ide/development-workflows","pageMetadata":{"title":"Development Workflows","description":"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples","href":"/core-features/ide/development-workflows"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,li:`li`,ol:`ol`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Card,CardGroup,CodeBlock,Heading,Icon,Note,OptimizedImage,Step,Steps}=_components;if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Icon)_missingMdxReference(`Icon`,true);if(!Note)_missingMdxReference(`Note`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Focus:`}),` Master the development workflows for different types of data applications, from dbt transformations to Python scripts and interactive Streamlit dashboards.`]}),`\n`,_jsx(_components.p,{children:`The 5X IDE provides specialized development environments for the most common data development tasks. This guide covers practical workflows for building data models, applications, and dashboards with real examples and best practices.`}),`\n`,_jsxs(Note,{children:[_jsx(_components.p,{children:_jsx(_components.strong,{children:`Development Environment`})}),_jsx(_components.p,{children:`The IDE comes pre-configured with multiple Python versions, dbt environments, and development tools. No additional setup required for basic development tasks.`})]}),`\n`,_jsx(Heading,{level:`2`,id:`python-development`,children:`Python development`}),`\n`,_jsx(Heading,{level:`3`,id:`python-environment-overview`,children:_jsx(_components.strong,{children:`Python environment overview`})}),`\n`,_jsx(_components.p,{children:`The IDE comes pre-installed with multiple Python versions managed through pyenv, providing flexibility for different project requirements and dependency compatibility.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Available Python versions:`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Python 3.8.20`}),` - Extended legacy support for older projects`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Python 3.9.23`}),` - Legacy support for older projects`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Python 3.10.18`}),` - Stable version with good package compatibility`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Python 3.11.13`}),` - Default version (set by PYENV_VERSION)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Python 3.12.11`}),` - Latest stable with performance improvements`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Python 3.13.4`}),` - Cutting-edge features and optimizations`]}),`\n`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`View installed versions:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`ls`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` /root/.pyenv/versions`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`virtual-environment-management`,children:_jsx(_components.strong,{children:`Virtual environment management`})}),`\n`,_jsx(_components.p,{children:`Python virtual environments provide isolated dependency management for your projects, preventing conflicts between different project requirements.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Create a virtual environment:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`5`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`5`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Using Python 3.11.13 (default)`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`/root/.pyenv/versions/3.11.13/bin/python`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -m`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` venv`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` my_project_env`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Using specific Python version`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`/root/.pyenv/versions/3.10.18/bin/python`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -m`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` venv`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` legacy_project_env`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Activate and manage environments:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`8`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`8`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Activate environment`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`source`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` my_project_env/bin/activate`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Verify active environment (should show your env path)`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`which`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` python`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Deactivate when finished`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`deactivate`})}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`dependency-management-best-practices`,children:_jsx(_components.strong,{children:`Dependency management best practices`})}),`\n`,_jsx(_components.p,{children:`Maintain project dependencies using requirements.txt files for reproducible environments across team members and deployment targets.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Create requirements.txt:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`16`,language:`text`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`text`,children:_jsxs(_components.code,{language:`text`,numberOfLines:`16`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`# Core data processing`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`pandas==2.0.3`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`numpy==1.24.3`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`# API and web requests `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`requests==2.31.0`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`urllib3==2.0.4`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`# Visualization`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`matplotlib==3.7.2`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`seaborn==0.12.2`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`# Development tools`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`jupyter==1.0.0`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`pytest==7.4.0`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})})]})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Install and manage dependencies:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`9`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`9`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Activate environment first`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`source`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` my_project_env/bin/activate`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Install from requirements file`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`pip`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` install`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -r`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` requirements.txt`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Install additional packages and update requirements`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`pip`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` install`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` scikit-learn==`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1.3.0`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`pip`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` freeze`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` >`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` requirements.txt`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`python-development-examples`,children:_jsx(_components.strong,{children:`Python development examples`})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Data processing script:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`27`,language:`python`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`python`,children:_jsxs(_components.code,{language:`python`,numberOfLines:`27`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`import`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` pandas `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`as`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` pd`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`import`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` numpy `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`as`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` np`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`from`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` sqlalchemy `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`import`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` create_engine`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`def`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` process_customer_data`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`connection_string`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`):`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"\"\"Process customer data from warehouse\"\"\"`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` engine `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` create_engine(connection_string)`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # Load data`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` pd.read_sql(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"SELECT * FROM customers\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, engine)`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # Data transformations`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'full_name'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`] `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'first_name'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`] `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`+`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` ' '`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` +`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'last_name'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`]`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'customer_tier'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`] `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` pd.cut(df[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'total_spent'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`], `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:` bins`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`[`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`0`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`100`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`500`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1000`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#4EC9B0`},children:`float`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'inf'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)],`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:` labels`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'Bronze'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'Silver'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'Gold'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'Platinum'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`])`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # Save processed data`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df.to_sql(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'processed_customers'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, engine, `}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:`if_exists`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'replace'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:`index`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`False`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:` return`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`if`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#9CDCFE`},children:` __name__`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` ==`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"__main__\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # Your connection string here`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` conn_str `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"your_connection_string\"`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` result `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` process_customer_data(conn_str)`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` print`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`f`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Processed `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`{`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`len`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(result)`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`}`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` customers\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`API integration example:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`31`,language:`python`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`python`,children:_jsxs(_components.code,{language:`python`,numberOfLines:`31`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`import`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` requests`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`import`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` json`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`from`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` datetime `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:`import`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` datetime`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`class`}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#4EC9B0`},children:` DataAPI`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` def`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` __init__`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`base_url`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`api_key`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`):`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.base_url `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` base_url`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.headers `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` {`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'Authorization'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`f`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'Bearer `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`{`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`api_key`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`}`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` def`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` fetch_data`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`endpoint`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`params`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`None`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`):`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"\"\"Fetch data from API endpoint\"\"\"`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` response `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` requests.get(`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` f`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`{`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.base_url`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`}`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`/`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`{`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`endpoint`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`}`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:` headers`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.headers,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:` params`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`params`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` )`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` response.raise_for_status()`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:` return`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` response.json()`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` def`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` process_and_save`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`endpoint`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`db_connection`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`):`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` \"\"\"Fetch, process, and save data to database\"\"\"`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` data `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` self`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.fetch_data(endpoint)`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # Process data`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` pd.DataFrame(data)`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df[`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'processed_at'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`] `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` datetime.now()`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # Save to database`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df.to_sql(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'api_data'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, db_connection, `}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:`if_exists`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'append'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#9CDCFE`},children:`index`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:`False`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#C586C0`},children:` return`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` df`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`dbt-development`,children:`dbt development`}),`\n`,_jsx(Heading,{level:`3`,id:`dbt-power-user-extension-recommended-approach`,children:_jsx(_components.strong,{children:`dbt Power User extension (recommended approach)`})}),`\n`,_jsx(_components.p,{children:`The dbt Power User extension provides the most integrated development experience, automatically using your configured dbt settings from Settings → Credentials including version selection, database connections, and target configuration.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=5922e0a3cd58a502f26a5452cd7aaf8d`,alt:`dbt Power User Extension`,style:{borderRadius:`12px`,boxShadow:`0 4px 12px rgba(0, 0, 0, 0.1)`},\"data-og-width\":`2638`,width:`2638`,\"data-og-height\":`1560`,height:`1560`,\"data-path\":`images/ide/ide-dbt-extension.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?w=280\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=928b1161ff967870fbf38dd8b3b0f3e2 280w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?w=560\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=72edcce6530cea146bfffd96392ffda9 560w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?w=840\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=332d3898b59b11cc94996dd50814139b 840w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?w=1100\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=58d35fe0d1ee4df85545e3047589d637 1100w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?w=1650\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=d52a3186a9e427e62293d36d838696e6 1650w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-dbt-extension.png?w=2500\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=39c3a56ef4b6e921576e198e457fd9b6 2500w`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Key workflows:`})}),`\n`,_jsxs(CardGroup,{cols:2,children:[_jsxs(Card,{title:`Model execution`,icon:`play`,children:[_jsx(_components.p,{children:_jsx(_components.strong,{children:`Run and test models`})}),_jsx(_components.p,{children:`Execute individual models, selections, or entire dbt projects with integrated test runner`})]}),_jsxs(Card,{title:`Lineage visualization`,icon:`project-diagram`,children:[_jsx(_components.p,{children:_jsx(_components.strong,{children:`Understand dependencies`})}),_jsx(_components.p,{children:`Interactive dependency graphs showing upstream and downstream model relationships`})]}),_jsxs(Card,{title:`Documentation`,icon:`book`,children:[_jsx(_components.p,{children:_jsx(_components.strong,{children:`Generate docs`})}),_jsx(_components.p,{children:`Create and view dbt documentation with integrated preview and automatic refresh`})]}),_jsxs(Card,{title:`SQL compilation`,icon:`code`,children:[_jsx(_components.p,{children:_jsx(_components.strong,{children:`Preview compiled SQL`})}),_jsx(_components.p,{children:`See the actual SQL that will be executed before running models`})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`command-line-dbt-development`,children:_jsx(_components.strong,{children:`Command-line dbt development`})}),`\n`,_jsx(_components.p,{children:`For users preferring terminal-based workflows, the IDE provides pre-configured dbt virtual environments for each supported version.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Activate dbt environment:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`8`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`8`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# List available dbt environments`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`ls`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` /root/.venv`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Activate specific dbt version`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`source`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` /root/.venv/dbt-1.8.9/bin/activate`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Verify dbt installation`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --version`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Available dbt versions:`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`dbt-1.6.18`}),` (`,_jsx(_components.code,{children:`/root/.venv/dbt-1.6.18/`}),`) - Legacy support`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`dbt-1.7.19`}),` (`,_jsx(_components.code,{children:`/root/.venv/dbt-1.7.19/`}),`) - Stable version`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`dbt-1.8.9`}),` (`,_jsx(_components.code,{children:`/root/.venv/dbt-1.8.9/`}),`) - Current stable`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`dbt-1.9.10`}),` (`,_jsx(_components.code,{children:`/root/.venv/dbt-1.9.10/`}),`) - Latest features`]}),`\n`]}),`\n`,_jsx(Heading,{level:`3`,id:`dbt-development-workflow`,children:_jsx(_components.strong,{children:`dbt development workflow`})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Common dbt commands:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`15`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`15`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Navigate to your dbt project directory`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`cd`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` /path/to/your/dbt/project`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Run entire project`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` run`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Run specific models`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` run`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --select`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` staging.stg_customers+`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Test your models`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` test`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Generate documentation`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` docs`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` generate`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` docs`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` serve`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Model development example:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`14`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`14`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- models/staging/stg_customers.sql`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` customer_id::`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`int`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` customer_id,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` LOWER`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`TRIM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(email)) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` email,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` INITCAP(first_name) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` first_name,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` INITCAP(last_name) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` last_name,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` created_at::`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`timestamp`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` created_at,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` CASE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` WHEN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` status`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` =`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'A'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` THEN`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'active'`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` WHEN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` status`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` =`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'I'`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` THEN`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'inactive'`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ELSE`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'unknown'`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` END`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` status`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` {{ source(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'crm'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'customers'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) }}`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`WHERE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` customer_id `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`IS NOT NULL`})]}),`\n`]})})}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Model testing:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`17`,language:`yaml`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`yaml`,children:_jsxs(_components.code,{language:`yaml`,numberOfLines:`17`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# models/schema.yml`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:`version`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:`models`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:`name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`stg_customers`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` description`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Cleaned customer data from CRM system\"`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` columns`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:`name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`customer_id`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` description`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Unique customer identifier\"`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` tests`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`unique`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`not_null`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:`name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`email`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` description`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`\"Customer email address\"`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#569CD6`},children:` tests`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`:`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`not_null`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` - `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`unique`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`lineage-visualization`,children:_jsx(_components.strong,{children:`Lineage visualization`})}),`\n`,_jsx(_components.p,{children:`The IDE provides powerful lineage visualization capabilities that help you understand data flow and model dependencies throughout your dbt project.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=0aacbb484ff6cc750633eca6e538bf44`,alt:`dbt Model Lineage Visualization`,style:{borderRadius:`12px`,boxShadow:`0 4px 12px rgba(0, 0, 0, 0.1)`},\"data-og-width\":`2082`,width:`2082`,\"data-og-height\":`1132`,height:`1132`,\"data-path\":`images/ide/ide-lineage-visualization.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?w=280\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=74d122281cab3975526d12e9298a6575 280w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?w=560\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=8e4dc012997c2aa56221b672b434954f 560w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?w=840\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=0108ce11399b766c57aac39ae06f9c24 840w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?w=1100\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=96b46cb9d8d8f2bd7f6ed06a50544380 1100w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?w=1650\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=ac9076e2b5c24d9cecd87c814539ab3d 1650w, https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/images/ide/ide-lineage-visualization.png?w=2500\u0026fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=6b73af887dafa92d4a7cdb74a3e1caae 2500w`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`To view lineage:`})}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsx(_components.li,{children:`Open any dbt model file in the editor`}),`\n`,_jsx(_components.li,{children:`Navigate to the Lineage tab in the IDE interface`}),`\n`,_jsxs(_components.li,{children:[`Explore interactive dependency graphs showing:`,`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`Upstream models and sources feeding into current model`}),`\n`,_jsx(_components.li,{children:`Downstream models consuming current model output`}),`\n`,_jsx(_components.li,{children:`Cross-project dependencies and external table references`}),`\n`]}),`\n`]}),`\n`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Lineage features:`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Interactive navigation`}),` - Click nodes to jump between related models`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Dependency depth control`}),` - Adjust how many levels of dependencies to display`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Impact analysis`}),` - Understand which models will be affected by changes`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Visual debugging`}),` - Identify circular dependencies and optimization opportunities`]}),`\n`]}),`\n`,_jsx(Heading,{level:`3`,id:`running-dbt-commands`,children:_jsx(_components.strong,{children:`Running dbt commands`})}),`\n`,_jsx(_components.p,{children:`Execute dbt commands directly from the IDE for any valid dbt project without leaving your development workspace.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`To run dbt commands:`})}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open dbt project`,children:_jsx(_components.p,{children:`Open a dbt project folder in the IDE`})}),_jsx(Step,{title:`Access dbt command interface`,children:_jsxs(_components.p,{children:[`Click on the `,_jsx(`span`,{style:{display:`inline-block`,verticalAlign:`middle`,width:`24px`,height:`24px`,margin:`0 4px`,color:`#000`},className:`dark:!mint-text-white`,children:_jsxs(`svg`,{width:`24`,height:`24`,viewBox:`0 0 16 16`,fill:`none`,xmlns:`http://www.w3.org/2000/svg`,children:[_jsxs(`g`,{clipPath:`url(#clip0)`,children:[_jsx(`path`,{d:`M7.29358 9.00631L6.41358 9.88552C6.27974 9.34717 5.96942 8.86905 5.53206 8.52735C5.09469 8.18564 4.55545 8 4.00024 8C3.44503 8 2.90579 8.18564 2.46843 8.52735C2.03107 8.86905 1.72075 9.34717 1.58691 9.88552L0.706911 9.00631L0.000244141 9.71234L1.14691 10.858L1.00024 11.0045V12.0036H0.000244141V13.0027H1.00024V13.056C1.05124 13.3815 1.14308 13.6993 1.27358 14.0018L0.000244141 15.294L0.706911 16L1.80691 14.901C2.06862 15.2346 2.40103 15.5062 2.78025 15.6962C3.15948 15.8862 3.57612 15.99 4.00024 16C4.42437 15.99 4.84101 15.8862 5.22023 15.6962C5.59946 15.5062 5.93187 15.2346 6.19358 14.901L7.29358 16L8.00024 15.294L6.72691 14.0018C6.85903 13.6929 6.9509 13.3683 7.00024 13.036V12.9694H8.00024V12.0036H7.00024V11.0045L6.85358 10.858L8.00024 9.71234L7.29358 9.00631ZM4.00024 9.00631C4.39807 9.00631 4.7796 9.16421 5.0609 9.44526C5.34221 9.72631 5.50024 10.1075 5.50024 10.505H2.50024C2.50024 10.1075 2.65828 9.72631 2.93958 9.44526C3.22089 9.16421 3.60242 9.00631 4.00024 9.00631ZM6.00024 13.0027C5.9514 13.5161 5.725 13.9965 5.35998 14.3612C4.99496 14.7259 4.51414 14.9521 4.00024 15.0009C3.48634 14.9521 3.00553 14.7259 2.64051 14.3612C2.27549 13.9965 2.04909 13.5161 2.00024 13.0027V11.5041H6.00024V13.0027Z`,fill:`currentColor`}),_jsx(`path`,{fillRule:`evenodd`,clipRule:`evenodd`,d:`M6.00024 7V2L14.9149 8.24024L9.00024 12.3805V11.1655L13.1812 8.24024L6.99524 3.91209V7H6.00024Z`,fill:`currentColor`})]}),_jsx(`defs`,{children:_jsx(`clipPath`,{id:`clip0`,children:_jsx(`rect`,{width:`16`,height:`16`,fill:`white`,transform:`translate(0.000244141)`})})})]})}),` icon from the top-right status bar`]})}),_jsx(Step,{title:`Go to terminal and activate dbt environment`,children:_jsx(CodeBlock,{filename:``,numberOfLines:`8`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`8`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# List available dbt environments`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`ls`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` /root/.venv`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Activate specific dbt version`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`source`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` /root/.venv/dbt-1.8.9/bin/activate`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Verify dbt installation`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --version`})]}),`\n`]})})})}),_jsx(Step,{title:`Enter command`,children:_jsx(_components.p,{children:`A command input box will appear, allowing you to enter the desired dbt command`})}),_jsx(Step,{title:`Execute command`,children:_jsx(_components.p,{children:`Confirm the command to execute it in the terminal`})})]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Terminal session management:`})}),`\n`,_jsx(_components.p,{children:`If similar commands were executed previously for the same project, the IDE will prompt you to either:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Open a new terminal session`}),` - Start a fresh terminal for the command`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Continue using existing terminal`}),` - Reuse the current terminal session`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`This integrated feature simplifies the dbt workflow, enabling you to build, test, and manage transformations without leaving your development workspace.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Example dbt commands:`})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`14`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`14`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Run all models`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` run`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Run specific models`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` run`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --select`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` staging.stg_customers+`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Test models`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` test`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Generate documentation`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` docs`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` generate`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`# Compile models`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`dbt`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` compile`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`cube-development`,children:`Cube development`}),`\n`,_jsx(Heading,{level:`3`,id:`cube-creation`,children:_jsx(_components.strong,{children:`Cube creation`})}),`\n`,_jsx(_components.p,{children:`Create new cubes directly from the IDE without leaving your development environment, providing a seamless and integrated experience for managing cube creation.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`To create a cube:`})}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open cubes repository`,children:_jsx(_components.p,{children:`Open any file within the cubes repository`})}),_jsx(Step,{title:`Access cube creation`,children:_jsxs(_components.p,{children:[`Click on the `,_jsx(Icon,{icon:`add`}),` icon located on the top-right corner of the status bar`]})}),_jsx(Step,{title:`Automatic server start`,children:_jsx(_components.p,{children:`The Cube Server will automatically start, enabling the cube creation process`})}),_jsx(Step,{title:`Select schema`,children:_jsx(_components.p,{children:`A new file tab will open, displaying a list of available schemas. Select the desired schema`})}),_jsx(Step,{title:`Define and create`,children:_jsx(_components.p,{children:`Proceed to define and create cubes as needed`})})]}),`\n`,_jsx(_components.p,{children:`This workflow provides a seamless and integrated experience for managing cube creation within the IDE, eliminating the need to switch between different tools or environments.`}),`\n`,_jsx(Heading,{level:`3`,id:`cube-server-start`,children:_jsx(_components.strong,{children:`Cube server start`})}),`\n`,_jsx(_components.p,{children:`Start the Cube Server for a specific active file tab directly from the IDE toolbar, giving you full control over active Cube Server sessions.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`To start the Cube Server:`})}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open cube file`,children:_jsx(_components.p,{children:`Open any file within your cubes repository`})}),_jsx(Step,{title:`Start server`,children:_jsxs(_components.p,{children:[`Click on the `,_jsx(Icon,{icon:`play`}),` icon from the IDE toolbar`]})}),_jsx(Step,{title:`Access server`,children:_jsxs(_components.p,{children:[`Once initiated, the Cube Server will launch and can be accessed locally via `,_jsx(_components.code,{children:`http://localhost:4000`})]})})]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Server conflict management:`})}),`\n`,_jsx(_components.p,{children:`If there is an existing Cube Server instance running, a prompt will appear asking you to:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Stop the currently active server and start a new one`}),` - Terminate the existing instance and launch a fresh server`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Cancel to retain the current session`}),` - Keep the existing server running`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`This ensures that multiple servers do not conflict and that you retain full control over active Cube Server sessions.`}),`\n`,_jsx(Heading,{level:`2`,id:`running-streamlit-applications-and-python-files`,children:`Running Streamlit applications and Python files`}),`\n`,_jsx(Heading,{level:`3`,id:`running-streamlit-applications`,children:_jsx(_components.strong,{children:`Running Streamlit applications`})}),`\n`,_jsx(_components.p,{children:`Run Streamlit applications directly from the IDE with automatic environment setup and dependency management.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`To run a Streamlit application:`})}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open Streamlit file`,children:_jsxs(_components.p,{children:[`Open the `,_jsx(_components.code,{children:`streamlit_app.py`}),` file from the Streamlit repository`]})}),_jsx(Step,{title:`Run application`,children:_jsxs(_components.p,{children:[`Click on the `,_jsx(Icon,{icon:`play`}),` icon in the IDE toolbar`]})}),_jsx(Step,{title:`Select Python version`,children:_jsx(_components.p,{children:`The IDE will prompt you to select the desired Python version for execution`})}),_jsx(Step,{title:`Automatic setup`,children:_jsx(_components.p,{children:`Upon confirmation, a virtual environment will be created automatically`})}),_jsx(Step,{title:`Install dependencies`,children:_jsxs(_components.p,{children:[`All dependencies listed in the `,_jsx(_components.code,{children:`requirements.txt`}),` file will be installed within the environment`]})}),_jsx(Step,{title:`Launch application`,children:_jsx(_components.p,{children:`Once setup is complete, the Streamlit application will launch successfully`})})]}),`\n`,_jsx(Heading,{level:`3`,id:`running-python-files`,children:_jsx(_components.strong,{children:`Running Python files`})}),`\n`,_jsx(_components.p,{children:`Execute standalone Python scripts with the same streamlined workflow as Streamlit applications.`}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`To run a Python file:`})}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open Python file`,children:_jsxs(_components.p,{children:[`Open any Python file (`,_jsx(_components.code,{children:`.py`}),`) in the IDE`]})}),_jsx(Step,{title:`Run script`,children:_jsxs(_components.p,{children:[`Click on the `,_jsx(`span`,{style:{display:`inline-block`,verticalAlign:`middle`,width:`24px`,height:`24px`,margin:`0 4px`,color:`#000`},className:`dark:!mint-text-white`,children:_jsx(`svg`,{width:`24`,height:`24`,viewBox:`0 0 16 16`,fill:`none`,xmlns:`http://www.w3.org/2000/svg`,children:_jsx(`path`,{fillRule:`evenodd`,clipRule:`evenodd`,d:`M10.9149 8.24024L2.00024 14.4805V2L10.9149 8.24024ZM2.99524 12.5684L9.18117 8.24024L2.99524 3.91209V12.5684ZM5.50024 14.4805V13.2511L12.6812 8.24024L5.50024 3.22935V2L14.4149 8.24024L5.50024 14.4805Z`,fill:`currentColor`})})}),` icon in the IDE toolbar`]})}),_jsx(Step,{title:`Select Python version`,children:_jsx(_components.p,{children:`Choose the desired Python version for execution`})}),_jsx(Step,{title:`Environment setup`,children:_jsx(_components.p,{children:`A virtual environment will be created automatically if needed`})}),_jsx(Step,{title:`Install dependencies`,children:_jsxs(_components.p,{children:[`Dependencies from `,_jsx(_components.code,{children:`requirements.txt`}),` will be installed automatically`]})}),_jsx(Step,{title:`Execute script`,children:_jsx(_components.p,{children:`The Python file will run successfully with output displayed in the terminal`})})]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`Benefits of integrated execution:`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Environment consistency`}),` - Automatic virtual environment creation ensures consistent execution environments`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Dependency management`}),` - Automatic installation of dependencies from `,_jsx(_components.code,{children:`requirements.txt`}),` reduces manual setup overhead`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Version selection`}),` - Choose the appropriate Python version for your project requirements`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Seamless workflow`}),` - Run applications and scripts without leaving the IDE or switching contexts`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`This process ensures environment consistency and reduces manual setup overhead for Streamlit or Python-based workflows, allowing you to focus on development rather than environment configuration.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Development Workflows","description":"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples","href":"/core-features/ide/development-workflows"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Python development","slug":"python-development","depth":2,"children":[{"title":"Python environment overview","slug":"python-environment-overview","depth":3,"children":[]},{"title":"Virtual environment management","slug":"virtual-environment-management","depth":3,"children":[]},{"title":"Dependency management best practices","slug":"dependency-management-best-practices","depth":3,"children":[]},{"title":"Python development examples","slug":"python-development-examples","depth":3,"children":[]}]},{"title":"dbt development","slug":"dbt-development","depth":2,"children":[{"title":"dbt Power User extension (recommended approach)","slug":"dbt-power-user-extension-recommended-approach","depth":3,"children":[]},{"title":"Command-line dbt development","slug":"command-line-dbt-development","depth":3,"children":[]},{"title":"dbt development workflow","slug":"dbt-development-workflow","depth":3,"children":[]},{"title":"Lineage visualization","slug":"lineage-visualization","depth":3,"children":[]},{"title":"Running dbt commands","slug":"running-dbt-commands","depth":3,"children":[]}]},{"title":"Cube development","slug":"cube-development","depth":2,"children":[{"title":"Cube creation","slug":"cube-creation","depth":3,"children":[]},{"title":"Cube server start","slug":"cube-server-start","depth":3,"children":[]}]},{"title":"Running Streamlit applications and Python files","slug":"running-streamlit-applications-and-python-files","depth":2,"children":[{"title":"Running Streamlit applications","slug":"running-streamlit-applications","depth":3,"children":[]},{"title":"Running Python files","slug":"running-python-files","depth":3,"children":[]}]}],"codeExamples":{}},"jsLinks":[],"dynamicCss":".dark\\:\\!mint-text-white:is(.dark *) {\n --tw-text-opacity: 1 !important;\n color: rgb(255 255 255 / var(--tw-text-opacity, 1)) !important\n}","subdomain":"5x","siteName":"5X Documentation","title":"Development Workflows - 5X Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2025-12-03T04:58:32.514Z","originalFileLocation":"core-features/ide/development-workflows.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples\">\u003cmeta data-mint-head name=\"application-name\" content=\"5X Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Development Workflows - 5X Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"5X Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.5x.co/core-features/ide/development-workflows\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://5x.mintlify.site/_mintlify/api/og/v2?division=IDE\u0026amp;title=Development+Workflows\u0026amp;description=Learn+how+to+develop+dbt+models%2C+Python+applications%2C+Streamlit+dashboards%2C+and+Metrics+project+using+the+IDE+with+best+practices+and+examples\u0026amp;theme=a80b561c5e91af23aa3bb85b\u0026amp;signature=3ac15a8da4966bd21caf87d0f4c0b7deb4a7895e25dc1a60316094cea19b40d2\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Development Workflows - 5X Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://5x.mintlify.site/_mintlify/api/og/v2?division=IDE\u0026amp;title=Development+Workflows\u0026amp;description=Learn+how+to+develop+dbt+models%2C+Python+applications%2C+Streamlit+dashboards%2C+and+Metrics+project+using+the+IDE+with+best+practices+and+examples\u0026amp;theme=a80b561c5e91af23aa3bb85b\u0026amp;signature=3ac15a8da4966bd21caf87d0f4c0b7deb4a7895e25dc1a60316094cea19b40d2\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/5x/EzU7T5jy0HFZy0JT/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"5X Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#2D2D2D\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.5x.co/core-features/ide/development-workflows\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/core-features/ide/development-workflows.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.5x.co/#organization\",\"name\":\"5X Documentation\",\"url\":\"https://docs.5x.co\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/5x/F78wdgJnT4aJ3lPl/logo/light.svg?fit=max\u0026auto=format\u0026n=F78wdgJnT4aJ3lPl\u0026q=85\u0026s=eefffb90a08eb6221be43529248d5180\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.5x.co#website\",\"name\":\"5X Documentation\",\"url\":\"https://docs.5x.co\",\"publisher\":{\"@id\":\"https://docs.5x.co/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.5x.co/core-features/ide/development-workflows#webpage\",\"url\":\"https://docs.5x.co/core-features/ide/development-workflows\",\"name\":\"Development Workflows\",\"description\":\"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples\",\"dateModified\":\"2025-12-03T04:58:32.514Z\",\"isPartOf\":{\"@id\":\"https://docs.5x.co#website\"},\"breadcrumb\":{\"@id\":\"https://docs.5x.co/core-features/ide/development-workflows#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.5x.co/core-features/ide/development-workflows#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Core Features\",\"item\":\"https://docs.5x.co/core-features\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IDE\",\"item\":\"https://docs.5x.co/core-features/ide/overview\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Development Workflows\",\"item\":\"https://docs.5x.co/core-features/ide/development-workflows\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.5x.co/core-features/ide/development-workflows#article\",\"headline\":\"Development Workflows\",\"name\":\"Development Workflows\",\"description\":\"Learn how to develop dbt models, Python applications, Streamlit dashboards, and Metrics project using the IDE with best practices and examples\",\"url\":\"https://docs.5x.co/core-features/ide/development-workflows\",\"mainEntityOfPage\":{\"@id\":\"https://docs.5x.co/core-features/ide/development-workflows#webpage\"},\"dateModified\":\"2025-12-03T04:58:32.514Z\",\"publisher\":{\"@id\":\"https://docs.5x.co/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.5x.co#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"5X Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"5X Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/core-features/ide/development-workflows.md","siteName":"5X Documentation","nav":{"global":{"anchors":[{"anchor":"Blog","icon":"newspaper","href":"https://www.5x.co/blogs"}]},"tabs":[{"tab":"Guides","groups":[{"group":"Get Started","pages":[{"title":"Welcome to 5X","href":""},{"group":"Quickstart Guide","pages":[{"title":"Overview","href":"/quickstart"},{"title":"Steps 1-3: Account Setup and Workspace Provisioning","href":"/quickstart/step-1-create-account"},{"title":"Step 4: Configure app connections and credentials","href":"/quickstart/step-4-app-connections-credentials"},{"title":"Step 5: Ingest Your Data","href":"/quickstart/step-5-ingest-data"},{"title":"Step 6: Explore Your Data","href":"/quickstart/step-6-explore-data"},{"title":"Step 7: Invite Your Team","href":"/quickstart/step-7-invite-team"},{"title":"Step 8: What's Next?","href":"/quickstart/step-8-next-steps"}]}]},{"group":"Core Features","pages":[{"title":"Overview","href":"/core-features"},{"group":"Ingestion","pages":[{"title":"Overview","href":"/core-features/ingestion/Overview"},{"title":"Connector Setup","href":"/core-features/ingestion/connector-setup"},{"title":"Connector Management","href":"/core-features/ingestion/connector-management"},{"title":"Monitoring \u0026 Alerts","href":"/core-features/ingestion/monitoring-alerts"}]},{"group":"IDE","pages":[{"title":"Overview","href":"/core-features/ide/overview"},{"title":"Setting up the IDE","href":"/core-features/ide/setup"},{"title":"IDE Interface","description":"Navigate the IDE interface, understand core components, and master the development environment for efficient data development","href":"/core-features/ide/interface"},{"title":"Development Workflows","href":"/core-features/ide/development-workflows"},{"title":"Migrating to VS code IDE","description":"A practical guide to migrate smoothly to the 5X VS Code–based IDE with setup, workflows, and best practices","href":"/core-features/ide/moving-from-legacy-ide-to-vscode"}]},{"group":"Jobs","pages":[{"title":"Overview","href":"/core-features/orchestration/overview"},{"title":"Workflow builder","href":"/core-features/orchestration/workflow-builder"},{"title":"Datasets \u0026 SQL Lab","href":"/core-features/orchestration/execution-monitoring"},{"title":"Alerting \u0026 notifications","href":"/core-features/orchestration/alerting"}]},{"group":"Business Intelligence","pages":[{"title":"Overview","href":"/core-features/business-intelligence/overview"},{"title":"App connections","href":"/core-features/business-intelligence/app-connections"},{"title":"Dashboard creation","href":"/core-features/business-intelligence/dashboard-creation"},{"title":"Chart building","href":"/core-features/business-intelligence/chart-building"},{"title":"Datasets \u0026 data exploration","href":"/core-features/business-intelligence/data-exploration"},{"title":"Dashboard embedding","href":"/core-features/business-intelligence/dashboard-embedding"}]},{"group":"Metrics Store","pages":[{"title":"Overview","href":"/core-features/metric-store/overview"},{"title":"Getting started","href":"/core-features/metric-store/getting-started"},{"title":"Project management","href":"/core-features/metric-store/project-management"},{"title":"Cube Playground","href":"/core-features/metric-store/cube-playground"},{"title":"API credentials","href":"/core-features/metric-store/api-credentials"},{"title":"BI integration","href":"/core-features/metric-store/bi-integration"},{"title":"Deployment options","href":"/core-features/metric-store/deployment-options"}]},{"group":"Data \u0026 AI Apps","pages":[{"title":"Overview","href":"/core-features/data-ai-apps/overview"},{"title":"Creating Data \u0026 AI Apps","href":"/core-features/data-ai-apps/app-creation"},{"title":"Publishing \u0026 Deployment","href":"/core-features/data-ai-apps/publishing"}]},{"group":"Conversational AI","pages":[{"title":"Overview","href":"/core-features/conversational-ai/overview"},{"title":"Chats types","href":"/core-features/conversational-ai/chats"},{"title":"Query, Tables, Charts","href":"/core-features/conversational-ai/querytablescharts"}]}]}]}]},"basePath":"","title":"Development Workflows - 5X Documentation","deploymentId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","buildId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-BguUeq2N.js","lightbox-handle-r17bVUz3.js"]}