The only Open-Source Self-Service Analytics Platform You NeedGet Started FreeAI InsightsTRY IT NOWData Connectivity without BlackboxesGet started freeBuild a Reporting SystemGet Started FreeEmpower Your Team – Build Self-Service Analytics in MinutesGet Started FreeLog inGet StartedALL RESOURCESBlog ArticlesUse Cases & ExamplesGuides & ResourcesDashboard TemplatesCase StudiesVideosPodcastWebinarsTestimonialsGlossaryGlossary0-9AARRAY_CONCATARRAY (in SQL)ARRAY_LENGTHARRAY_REVERSEARRAY_TO_STRINGAnalytics-Ready DataARRAY Type Consistency ACID ComplianceAttribute HierarchyALTER MATERIALIZED VIEW (BigQuery)Abstraction (in Data Modeling) Array FieldsApplication-Aware ModelingAI-Powered Data ModelingBBYTE_LENGTH FunctionBigQuery ConsoleBigQuery Performance OptimizationBigQuery StudioBusiness-Ready DataBigQuery Data SourceBigQuery MLBigQuery ConnectorBusiness Intelligence DashboardsCCAST AS BOOLCAST AS TIMESTAMPCURRENT_DATE FunctionCAST AS FLOAT64CAST AS DATETIMECAST AS INTERVALCustom Query ConnectionCAST AS STRINGCRM MarketingCAST AS TIMECASTCASE in ARRAY_LENGTHCAST AS DATECHAR_LENGTH FunctionCAST AS STRUCTCross-Device User ProfilesCOALESCE in ARRAYCustom Events in GA4CRM Data InsightsCAST AS BYTESCAST AS ARRAYCAST AS NUMERICCAST AS BIGNUMERICCost Data BlendingCAST AS INT64CONTAINS_SUBSTR FunctionCTE Query Optimization TechniquesCTE vs Temporary TableCommon Table Expression (CTE)Clustering in ViewsCloud ETL ToolsCREATE MATERIALIZED VIEW (BigQuery)Class (in Data Modeling)CREATE MODEL (BigQuery ML)Conceptual Data Modeling ToolCollaborative DiagrammingDDATE_ADD FunctionData Modeling for Business ReportingData Quality MetricsData Quality IssuesData StandardizationData AmbiguityDATE_FROM_UNIX_DATEDATE_DIFF FunctionDATE_TRUNC FunctionDATE_SUB FunctionData Quality FrameworkData Quality MonitoringData Modeling in RetailData Modeling in HealthcareData ProductData IntegrityData RedundancyData Mart ArchitectureData Vault SchemaData Source SchemaDependent Data MartData Modeling Best PracticesData Mart (in OWOX Reports)Data Modeling StagesData DriftData SkewData Model TypesDimension TableData Modeling TechniquesData Modeling ProcessDROP MATERIALIZED VIEW (BigQuery)Data Modeling MistakesData LakehouseData Security Cost ConsiderationsData Security GovernanceData Security StandardsData AnalystData Privacy GovernanceData Privacy for SnowflakeData Privacy for BigQueryData Privacy for dbtData Anomaly DetectionData Analysis ToolsData MaskingData GraphData ExplorationData Driven Decision MakingData AnonymizationDynamic SQLDrag-and-Drop InterfaceDerived ModelDerived AttributeDecentralized Data TeamData Modeling GranularityData Modeling ConventionsData Modeling DocumentationData Model VersioningData Model PartitioningData Model OptimizationData LayerDatabase Schema LineageDatabase Schema DiagramDatabase LogicDatabase Diagram ToolData Transformation ToolsData Transformation FrameworksData Team Culture Data StreamingData ReplicationData Quality for SnowflakeData Quality for dbtDa