Genomic data in Parquet format on Azure

Published Feb 10 2022 10:09 AM 1,408 Views

One of the most common formats for genomic data is Variant Call Format (VCF). VCF is a text file format, most likely stored in a compressed manner. It contains meta-information, a header, and data lines containing tab-separated text fields with genotype information. VCF is accepted and processed by many genomic tools, but not natively supported by interactive and serverless technologies like Azure Synapse, AWS Athena, Google BigQuery. 

Olesya_Melnichenko_0-1644514234748.jpeg

 

Parquet is an open-source columnar storage format designed to bring efficiency compared to row-based files. It stores metadata and supports complex nested data structures. The layout of Parquet data files is optimized for queries that process large volumes of data.  It is a recognized file format used by many systems, and it works great with serverless analytics solutions. 

 

Due to the wide support of Parquet, having data in this format is beneficial for multiple scenarios. If you want to explore a dataset, you can run ad-hoc queries on Parquet files and get results several times faster and at less cost compared to row-based formats. If you want to incorporate genomic data into your machine learning models, you can read Parquet files from your Notebooks. You can even create your own genomic databaseParquet files ingestion is well supported by many big data analytics platforms. 

 

We converted two Azure Genomics Data Lake datasets from VCF to Parquet: 1000 Genomes variant call information (release 20130502) and gnomAD v2.1.1, to make this data more accessible, especially for people without extensive genomics background. Datasets in Parquet format are publicly available for queries and exploration. 

 

Conversion from VCF to Parquet format 

To perform format conversion, we used Glow, an open-source toolkit for large-scale genomic analysis built on Apache Spark. To check notebooks used for dataset conversion and learn more about running them on Azure Databricks and Azure Synapse Analytics, visit our GitHub repository 

 

Query genomic data in Parquet format 

You can query Parquet files in Azure Synapse Analytics. Serverless SQL pool enables you to query data in your data lake. Billing for a serverless SQL pool is based on the amount of data processed to run the query and not the number of nodes used to run the query. 

 

Prerequisites: You need to have a Synapse workspace to perform analytics. Follow the instructions and create a workspace if needed (you can skip the last step and do not upload any sample data). 

 

First, we create a database with a data source that references genomic data storage account. We provide setup scripts and sample queries for 1000 Genomes and gnomAD datasets. Setup script will create the database, data sources, database scoped credentials, and external file formats. 

 

Open Synapse Studio, go to the Develop tab, open SQL script, and execute it. 

Olesya_Melnichenko_1-1644514234750.png

 

Go to the Data tab to check that the database and table were created. Now you are ready to run sample queries. 

Olesya_Melnichenko_2-1644514234752.png

 

To check the amount of data processed to run a query go to the Monitor tab. 

Olesya_Melnichenko_3-1644514234738.png

 

Data schema 

Default Glow schema mirrors a single row of a VCF file. Information that applies to an entire variant, such as the contig name, start and end positions, and INFO attributes, is contained in columns. The genotypes, which correspond to the GT FORMAT fields in a VCF, are contained in an array with one entry per sample. Each entry is a structure with fields that are described in the VCF header.  

 

gnomAD dataset in Parquet format has Glow schema with removed genotypes and added hashId. The genotypes are removed since they do not contain any information in this dataset. Column hashId could be used as a unique variant id and is constructed as the hash code of all columns except genotypes using the 64-bit variant of the xxHash algorithm. Detailed gnomAD schema description is available at https://datasetgnomadparquet.blob.core.windows.net/dataset/v2.1.1/dataSchema_exomes.txt and https://datasetgnomadparquet.blob.core.windows.net/dataset/v2.1.1/dataSchema_genomes.txt 

 

For 1000 Genomes dataset we created 2 copies of data with different schema: 

  • Glow schema with added hashId 
  • Flattened schema (Information that applies to an entire variant, hashId included, stays the same. The genotypes get replaced by a set of columns, one per each struct field - to achieve that we copy variant information for each entry of genotypes array)

To compare 1000 Genomes data schemas check SQL scripts with sample queries for flattened and nested data.  

 

References 

  1. Azure Synapse Analytics | Microsoft Azure 
  2. Genomics Data Lake - Azure Open Datasets | Microsoft Docs 
  3. genomicsnotebook/vcf2parquet-conversion at main · microsoft/genomicsnotebook · GitHub 
  4. Glow (projectglow.io) 
  5. HTS format specifications (samtools.github.io) 

 

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3150554%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EGenomic%20data%20in%20Parquet%20format%20on%20Azure%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3150554%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EOne%20of%20the%20most%20common%20formats%20for%20genomic%20data%20is%20Variant%20Call%20Format%20(%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fsamtools.github.io%2Fhts-specs%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%3EVCF%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E).%20VCF%20is%20a%20text%20file%20format%2C%20most%20likely%20stored%20in%20a%20compressed%20manner.%20It%20contains%20meta-information%2C%20a%20header%2C%20and%20data%20lines%20containing%20tab-separated%20text%20fields%20with%20genotype%20information.%20VCF%20is%20accepted%20and%20processed%20by%20many%20genomic%20tools%2C%20but%20not%20natively%20supported%20by%20interactive%20and%20serverless%20technologies%20like%20Azure%20Synapse%2C%20AWS%20Athena%2C%20Google%20BigQuery.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347087i1B064054CF1754E0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Olesya_Melnichenko_0-1644514234748.jpeg%22%20alt%3D%22%5C%26quot%3BOlesya_Melnichenko_0-1644514234748.jpeg%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fparquet.apache.org%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%3EParquet%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20is%20an%20open-source%20columnar%20storage%20format%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3Edesigned%20to%20bring%20efficiency%20compared%20to%20row-based%20files%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E.%20It%20stores%20metadata%20and%20supports%20complex%20nested%20data%20structures.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EThe%20layout%20of%20Parquet%20data%20files%20is%20optimized%20for%20queries%20that%20process%20large%20volumes%20of%20data.%20%E2%80%AFIt%20is%20a%20recognized%20file%20format%20used%20by%20many%20systems%2C%20and%20it%20works%20great%20with%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eserverless%20analytics%20solutions%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%3EDue%20to%20the%20wide%20support%20of%20Parquet%2C%20having%20data%20in%20this%20format%20is%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Ebeneficial%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%3Efor%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20multiple%20scenarios.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3EIf%20you%20want%20to%20explore%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E%20a%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20dataset%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E%2C%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20you%20can%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Erun%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Ead-hoc%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Equeries%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Eon%20Parquet%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Efiles%20and%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20get%20results%20several%20times%20faster%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Eand%20at%20less%20cost%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20compared%20to%20row-based%20formats%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3EIf%20you%20want%20to%20incorporate%20genomic%20data%20into%20your%20machine%20learning%20models%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E%2C%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20you%20can%20read%20Pa%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Erquet%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Efiles%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20from%20your%20Not%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Eebooks.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20You%20can%20even%20create%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20your%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Eown%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Egenomic%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Edatabase%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20%E2%80%93%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3EParquet%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Efiles%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Eingestion%20is%20well%20supporte%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Ed%20by%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3Emany%20big%20data%20analytics%20platforms.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EWe%20converted%20two%20Azure%20Genomics%20Data%20Lake%20datasets%20from%20VCF%20to%20Parquet%3A%20%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-1000-genomes%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3E1000%20Genomes%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E%20variant%20call%20information%20(release%2020130502)%20and%20%26lt%3B%5C%2FSPAN%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-gnomad%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3EgnomAD%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E%20v2.1.1%2C%20to%20make%20this%20data%20more%20accessible%2C%20especially%20for%20people%20without%20extensive%20genomics%20background.%20Datasets%20in%20Parquet%20format%20are%20publicly%20available%20for%20queries%20and%20exploration.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CH4%20aria-level%3D%22%5C%26quot%3B2%5C%26quot%3B%22%20id%3D%22%5C%26quot%3Btoc-hId-1064228125%5C%26quot%3B%22%20id%3D%22toc-hId-1064229179%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EConversion%20from%20VCF%20to%20Parquet%20format%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A40%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FH4%26gt%3B%5Cn%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3ETo%20perform%20format%20conversion%2C%20we%20used%20%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fprojectglow.io%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%3EGlow%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%2C%20an%20open-source%20toolkit%20for%20large-scale%20genomic%20analysis%20built%20on%20Apache%20Spark.%20To%20check%20notebooks%20used%20for%20dataset%20conversion%20and%20learn%20more%20about%20running%20them%20on%20Azure%20Databricks%20and%20Azure%20Synapse%20Analytics%2C%20visit%20our%20%26lt%3B%5C%2FSPAN%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fgenomicsnotebook%2Ftree%2Fmain%2Fvcf2parquet-conversion%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3EGitHub%20repository%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E.%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FH4%3E%3CH4%20aria-level%3D%22%5C%26quot%3B2%5C%26quot%3B%22%20id%3D%22%5C%26quot%3Btoc-hId--743226338%5C%26quot%3B%22%20id%3D%22toc-hId--743225284%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EQuery%20genomic%20data%20in%20Parquet%20format%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A40%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FH4%26gt%3B%5Cn%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EYou%20can%20query%20Parquet%20files%20in%20Azure%20Synapse%20Analytics.%20Serverless%20SQL%20pool%20enables%20you%20to%20query%20data%20in%20your%20data%20lake.%20Billing%20for%20a%20serverless%20SQL%20pool%20is%20based%20on%20the%20amount%20of%20data%20processed%20to%20run%20the%20query%20and%20not%20the%20number%20of%20nodes%20used%20to%20run%20the%20query.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EPrerequisites%3A%20You%20need%20to%20have%20a%20Synapse%20workspace%20to%20perform%20analytics.%20Follow%20%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fget-started-create-workspace%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3Ethe%20instructions%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20and%20create%20a%20workspace%20if%20needed%20(you%20can%20skip%20the%20last%20step%20and%20do%20not%20upload%20any%20sample%20data).%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EFirst%2C%20we%20create%20a%20database%20with%20a%20data%20source%20that%20references%20genomic%20data%20storage%20account.%20We%20provide%20setup%20scripts%20and%20sample%20queries%20for%20%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fgenomicsnotebook%2Ftree%2Fmain%2Fvcf2parquet-conversion%2F1000genomes%2Fsql%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3E1000%20Genomes%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20and%20%26lt%3B%5C%2FSPAN%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fgenomicsnotebook%2Ftree%2Fmain%2Fvcf2parquet-conversion%2Fgnomad%2Fsql%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3EgnomAD%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20datasets.%20Setup%20script%20will%20create%20the%20database%2C%20data%20sources%2C%20database%20scoped%20credentials%2C%20and%20external%20file%20formats.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EOpen%20Synapse%20Studio%2C%20go%20to%20the%20Develop%20tab%2C%20open%20SQL%20script%2C%20and%20execute%20it.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347085iE7E6CD77ADD0D823%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Olesya_Melnichenko_1-1644514234750.png%22%20alt%3D%22%5C%26quot%3BOlesya_Melnichenko_1-1644514234750.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EGo%20to%20the%20Data%20tab%20to%20check%20that%20the%20database%20and%20table%20were%20created.%20Now%20you%20are%20ready%20to%20run%20sample%20queries.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347086iD2ED757A93D66B12%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Olesya_Melnichenko_2-1644514234752.png%22%20alt%3D%22%5C%26quot%3BOlesya_Melnichenko_2-1644514234752.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3ETo%20check%20the%20amount%20of%20data%20processed%20to%20run%20a%20query%20go%20to%20the%20Monitor%20tab.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347088i0E51313F86380F03%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Olesya_Melnichenko_3-1644514234738.png%22%20alt%3D%22%5C%26quot%3BOlesya_Melnichenko_3-1644514234738.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%20aria-level%3D%22%5C%26quot%3B2%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FH4%3E%3CH4%20aria-level%3D%22%5C%26quot%3B2%5C%26quot%3B%22%20id%3D%22%5C%26quot%3Btoc-hId-1744286495%5C%26quot%3B%22%20id%3D%22toc-hId-1744287549%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EData%20schema%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A40%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FH4%26gt%3B%5Cn%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EDefault%20Glow%20schema%20mirrors%20a%20single%20row%20of%20a%20VCF%20file.%20Information%20that%20applies%20to%20an%20entire%20variant%2C%20such%20as%20the%20contig%20name%2C%20start%20and%20end%20positions%2C%20and%20INFO%20attributes%2C%20is%20contained%20in%20columns.%20The%20genotypes%2C%20which%20correspond%20to%20the%20GT%20FORMAT%20fields%20in%20a%20VCF%2C%20are%20contained%20in%20an%20array%20with%20one%20entry%20per%20sample.%20Each%20entry%20is%20a%20structure%20with%20fields%20that%20are%20described%20in%20the%20VCF%20header.%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EgnomAD%20dataset%20in%20Parquet%20format%20has%20Glow%20schema%20with%20removed%20genotypes%20and%20added%20hashId.%20The%20genotypes%20are%20removed%20since%20they%20do%20not%20contain%20any%20information%20in%20this%20dataset.%20Column%20hashId%20could%20be%20used%20as%20a%20unique%20variant%20id%20and%20is%20constructed%20as%20the%20hash%20code%20of%20all%20columns%20except%20genotypes%20using%20the%2064-bit%20variant%20of%20the%20xxHash%20algorithm.%20Detailed%20gnomAD%20schema%20description%20is%20available%20at%20%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdatasetgnomadparquet.blob.core.windows.net%2Fdataset%2Fv2.1.1%2FdataSchema_exomes.txt%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%3Ehttps%3A%2F%2Fdatasetgnomadparquet.blob.core.windows.net%2Fdataset%2Fv2.1.1%2FdataSchema_exomes.txt%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20and%20%26lt%3B%5C%2FSPAN%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdatasetgnomadparquet.blob.core.windows.net%2Fdataset%2Fv2.1.1%2FdataSchema_genomes.txt%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%3Ehttps%3A%2F%2Fdatasetgnomadparquet.blob.core.windows.net%2Fdataset%2Fv2.1.1%2FdataSchema_genomes.txt%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EFor%201000%20Genomes%20dataset%20we%20created%202%20copies%20of%20data%20with%20different%20schema%3A%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3CUL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%EF%82%B7%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BSymbol%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B4%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B1%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EGlow%20schema%20with%20added%20hashId%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%5Cn%3CUL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%EF%82%B7%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BSymbol%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B4%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B1%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EFlattened%20schema%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FUL%26gt%3B%5Cn%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EInformation%20that%20applies%20to%20an%20entire%20variant%2C%20hashId%20included%2C%20stays%20the%20same.%20The%20genotypes%20get%20replaced%20by%20a%20set%20of%20columns%2C%20one%20per%20each%20struct%20field%20-%20to%20achieve%20that%20we%20copy%20variant%20information%20for%20each%20entry%20of%20genotypes%20array.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A720%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3ETo%20compare%201000%20genomes%20data%20schemas%20check%20SQL%20scripts%20with%20sample%20queries%20for%20%26lt%3B%5C%2FSPAN%26gt%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fgenomicsnotebook%2Fblob%2Fmain%2Fvcf2parquet-conversion%2F1000genomes%2Fsql%2FsampleQueriesFlattened.sql%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3Eflattened%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20and%20%26lt%3B%5C%2FSPAN%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fgenomicsnotebook%2Fblob%2Fmain%2Fvcf2parquet-conversion%2F1000genomes%2Fsql%2FsampleQueriesNested.sql%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%3Enested%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20data.%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20aria-level%3D%22%5C%26quot%3B2%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CH4%20aria-level%3D%22%5C%26quot%3B2%5C%26quot%3B%22%20id%3D%22%5C%26quot%3Btoc-hId--63167968%5C%26quot%3B%22%20id%3D%22toc-hId-1744287549%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EReferences%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A40%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FH4%26gt%3B%5Cn%3COL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%251.%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BCalibri%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B5%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B1%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fsynapse-analytics%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EAzure%20Synapse%20Analytics%20%7C%20Microsoft%20Azure%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3COL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%251.%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BCalibri%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B5%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B2%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-genomics-data-lake%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EGenomics%20Data%20Lake%20-%20Azure%20Open%20Datasets%20%7C%20Microsoft%20Docs%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3COL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%251.%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BCalibri%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B5%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B3%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fgenomicsnotebook%2Ftree%2Fmain%2Fvcf2parquet-conversion%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3Egenomicsnotebook%2Fvcf2parquet-conversion%20at%20main%20%C2%B7%20microsoft%2Fgenomicsnotebook%20%C2%B7%20GitHub%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3COL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%251.%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BCalibri%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B5%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B4%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fprojectglow.io%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EGlow%20(projectglow.io)%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3COL%3E%5Cn%3CLI%20data-leveltext%3D%22%5C%26quot%3B%251.%5C%26quot%3B%22%20data-font%3D%22%5C%26quot%3BCalibri%5C%26quot%3B%22%20data-listid%3D%22%5C%26quot%3B5%5C%26quot%3B%22%20aria-setsize%3D%22%5C%26quot%3B-1%5C%26quot%3B%22%20data-aria-posinset%3D%22%5C%26quot%3B5%5C%26quot%3B%22%20data-aria-level%3D%22%5C%26quot%3B1%5C%26quot%3B%22%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fsamtools.github.io%2Fhts-specs%2F%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3EHTS%20format%20specifications%20(samtools.github.io)%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FLI%26gt%3B%5Cn%26lt%3B%5C%2FOL%26gt%3B%5Cn%3CP%3E%3CSPAN%20data-ccp-props%3D%22%5C%26quot%3B%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A720%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-TEASER%20id%3D%22%5C%26quot%3Blingo-teaser-3150554%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3C%2FLINGO-TEASER%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347091i16F25C1E2450B640%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22MicrosoftGenomics-image.jpg%22%20alt%3D%22%5C%26quot%3BMicrosoftGenomics-image.jpg%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3EMaking%20genomic%20data%20more%20accessible%20with%20Parquet.%20Learn%20how%20transform%20and%20query%20data%20in%20Azure%20Synapse%20Analytics.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-teaser%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3150554%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EGenomics%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EAzure%20Synapse%20Analytics%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3ELife%20Sciences%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EHealthcare%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EAzure%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FH4%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FH4%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Version history
Last update:
‎Feb 10 2022 10:12 AM
Updated by: