FastBI Lake
Lake stores data in FastBI for querying. It is distinct from connecting to an external database and querying data there.
Bring data into Lake
Section titled “Bring data into Lake”Add files, synchronize a supported connector, or use a Job to bring selected data into Lake.
Upload files
Section titled “Upload files”In a conversation, select the paperclip (Upload files) to open Files. Choose Private or Organization, then Add file. Check the limits shown for your plan: small chat attachments and Lake files can have different retention and size rules. You can manage uploaded files under Connections → Manage files.
Synchronize a connector
Section titled “Synchronize a connector”Connectors such as Google Play, Apple App Store Connect, and Meta Ads can synchronize supported data into Lake for faster analysis. FastBI can query the synchronized data without fetching it from the provider again for each question.
Some connectors and report types require Lake synchronization before their data can be analyzed. Google Play report analysis and App Store Connect analytics, sales, and finance report analysis require the relevant reports to be in Lake. Enable the reports you need and wait for the first successful sync. For Meta Ads, Lake sync is optional.
Connector synchronization runs through Jobs. Inspect the completed run and resulting tables before analyzing newly synchronized data.
Bring selected data with Jobs
Section titled “Bring selected data with Jobs”Use Jobs to bring only the data needed for your analysis into Lake. Choose the reports, reporting level, and date range supported by the connector, or use a SQL query to select specific columns and filter rows. Set the destination and schedule to keep that selected dataset up to date.
Check freshness
Section titled “Check freshness”A connection being available does not mean its Lake data is current. Check the last successful ingestion and the date range represented in the table. A failed or incomplete run may leave the previously available data in place.
Manage usage
Section titled “Manage usage”Review Lake usage and billing in the app when planning recurring ingestion. Storage and query activity are separate considerations from the analysis questions you ask. Use the current in-app billing information for your organization’s limits and rates.
Pricing examples
Section titled “Pricing examples”See Lake scan and storage examples to estimate a workload and understand which charges are separate from Analysis seats.