From ContaAzul to BigQuery: managed, scheduled, no code.
Kondado replicates data from ContaAzul to BigQuery on a configurable schedule, offering 13 pipelines including Accounts Payable, Accounts Receivable, Sales, and People Registration with 571 fields total, enabling automated financial analytics without coding.
Kondado provides a direct connection between ContaAzul and BigQuery, enabling you to replicate your Brazilian accounting data to Google’s serverless data warehouse without writing code. Simply select ContaAzul as your data source, authenticate your account, and choose BigQuery as your destination. The platform handles the extraction and loading automatically on your preferred schedule, whether every 5 minutes, hourly, or daily. Once configured, your financial records flow continuously into BigQuery, ready for analysis alongside other business data sources.
With your ContaAzul data in BigQuery, you can build unified financial dashboards, automate cash flow reporting, and combine accounting metrics with sales or marketing data for complete business intelligence. The automated pipeline ensures your datasets stay current, eliminating manual exports and CSV uploads while maintaining data consistency for accurate decision-making.
The Accounts Payable and Accounts Receivable pipelines deliver comprehensive financial obligation and collection data directly into your BigQuery environment, enabling automated cash flow analysis and aging reports without manual spreadsheet work. With the Sales and Sales Details pipelines, you can analyze transaction patterns, product performance, and revenue trends alongside your accounting records to identify profitability drivers and seasonal variations. This consolidated financial data supports building custom reports in Looker Studio or Power BI, creating a single source of truth for financial decision-making and strategic planning across your entire organization.
Try out all the features for free for 14 days
Replicated to BigQuery
ContaAzul data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
13
available pipelines
571
extractable fields
BigQuery
Destination
Available integrations
People Registration: Details
Includes fields such as uuid, name, and email, along with information on active status and person type, either INDIVIDUAL or LEGAL.
People Registration
Contains data such as document, phone, and address, including details like neighborhood, city, and state, along with active status.
Accounts Payable
Presents information on financial obligations, including id, expected payment date, and reconciliation status.
Accounts Payable: Categories
Includes financial categories with fields such as id, name, and type, along with information on whether they should be considered as cost in the DRE.
Accounts Payable: Cost Centers
Provides data on cost centers, including id, name, and active status, along with a custom code for internal organization.
Accounts Receivable
Contains information on amounts receivable, including id, due date, and collection status, along with financial details.
Accounts Receivable: Categories
Includes accounts receivable categories with fields such as id, name, and type, along with information on whether they are considered revenue.
Accounts Receivable: Cost Centers
Provides data on cost centers related to accounts receivable, including id and name, along with active status.
Accounts Receivable: Collections
Includes information on collections, with fields such as id, status, and due date, along with relevant financial details.
Contracts
Contains data on contracts, including id, contracting party name, and status, along with associated financial information.
Sales
Data on sales transactions, including fields such as id, sale date, and total amount.
Sales Details
Detailed information on each sale, such as sale id, product, quantity, and unit price.
Sales Items
List of sold items, including fields such as item id, description, quantity, and value.
Sync data automatically — no code, no manual exports.
1
Connect ContaAzul to Kondado
Authenticate your ContaAzul account through Kondado's interface to establish the data source connection. Select your organization and grant permissions for the financial data you want to replicate.
2
Configure Your BigQuery Destination
Enter your BigQuery project details and specify the dataset where ContaAzul data should load. Kondado automatically creates the necessary tables and schemas for your selected pipelines.
3
Select Pipelines and Schedule Updates
Choose from the 13 available ContaAzul pipelines such as Accounts Payable and Sales, then set your preferred update frequency. Activate the pipeline to begin automated replication on your configured schedule.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending ContaAzul data to BigQuery automatically
How does the ContaAzul to BigQuery connection work?▼
Kondado uses a direct connection to extract data from your ContaAzul account and load it into BigQuery automatically. You authenticate your ContaAzul credentials once, select which pipelines to enable, and the platform handles the data transfer on your chosen schedule. The process requires no coding or manual file exports, maintaining a continuous flow of financial data into your data warehouse.
What specific data can I replicate from ContaAzul to BigQuery?▼
You can replicate 13 different pipelines covering People Registration, Accounts Payable, Accounts Receivable, Contracts, and Sales data with 571 total fields available. This includes customer details, payment schedules, cost centers, collection statuses, and line-item sales information. Each pipeline delivers structured data ready for SQL analysis and dashboard creation in your BigQuery environment.
How often does ContaAzul data update in BigQuery?▼
Kondado updates your ContaAzul data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. You select the frequency during setup based on your business needs for data freshness and analytical requirements. This automated approach ensures your BigQuery datasets reflect current financial positions without manual intervention.
Can I combine ContaAzul data with other sources in BigQuery?▼
Yes, once your ContaAzul data resides in BigQuery, you can join it with data from PostgreSQL, Google Sheets, or other business applications using standard SQL queries. This enables unified analysis across your entire technology stack, such as correlating accounting records with CRM or e-commerce data. BigQuery's analytical capabilities make cross-source reporting seamless and efficient.
What format does ContaAzul data take in BigQuery?▼
ContaAzul data loads into BigQuery as structured tables with preserved data types, including timestamps, decimals for monetary values, and categorical fields for status indicators. Each pipeline becomes a separate dataset table with consistent schemas that support complex querying and aggregation. The standardized format allows immediate use with BigQuery's built-in analytics functions and machine learning tools.
Are there pre-built dashboards available for ContaAzul data?▼
Yes, Kondado provides ready-made report templates including the Conta Azul Looker Studio Report and Conta Azul Power BI Report that connect directly to your BigQuery data. These templates offer immediate visualization of cash flow, receivables aging, and sales performance without requiring you to build charts from scratch. You can customize these reports further or use them as starting points for your own financial analytics in Looker Studio or Power BI.
Do I need coding skills to set up the ContaAzul BigQuery pipeline?▼
No coding is required to establish the connection between ContaAzul and BigQuery using Kondado's no-code interface. The platform provides a guided setup process where you simply authenticate your accounts, select desired pipelines, and configure your update schedule. Technical users can then leverage SQL for advanced analysis, while business users access the data through connected business intelligence tools.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
