Getting Started with Analytical Data Sharing
Here’s a quick overview of the steps to get started with Analytical Data Sharing.
Step 1: Connect Your Data Source
Connect to your existing data warehouse or database:
- Snowflake
- Cloudera CDP Hive
- MySQL and Compatible Databases
- PostgreSQL and Compatible Databases
- Amazon S3
- CSV Browser Upload
Step 2: Apply Data Transformations (Optional)
Before sharing your data, you can transform and prepare it to meet your specific sharing requirements. Vendia provides compute capabilities without requiring additional code:
Data Filtering
Apply row-based filters to create targeted datasets. You can filter data during ingestion or after ingesting all data into Vendia tables by creating new filtered (derived) Vendia tables:
- Filter by date ranges, regions, or business units
- Create tenant-specific or customer-specific datasets
- Apply conditional logic to include/exclude specific records
Dynamic Data Masking
Protect sensitive information while maintaining data utility. Like filtering, masking can be applied during ingestion or after ingesting all data into Vendia tables by creating new filtered (derived) Vendia tables:
- Mask personally identifiable information (PII)
- Redact confidential business data
Data Joins
Combine datasets from multiple sources to create enriched data products. Note: Data joins require first ingesting your data into Vendia tables, then creating new combined tables:
- Join tables from the same data source
- Combine data from different connected sources
- Create unified views across organizational boundaries
- Build comprehensive datasets for analytics
Workflow Options
Option 1: Transform During Ingestion Apply filtering and masking rules as you ingest data from your source systems.
Option 2: Ingest Then Transform Ingest all data into Vendia tables first, then create new filtered/masked (derived) Vendia tables.
These transformations ensure your shared data meets both your partners’ needs and your organization’s governance requirements.
Step 3: Choose Your Sharing Method
Option A: Share with Partners on Vendia Create shared tables for collaborative data enrichment and real-time updates.
Option B: Distribute to External Consumers Create data products in formats like Apache Iceberg, Delta Share, or CSV for platform-agnostic access.
Step 4: Invite Partners and Manage Access
Send email invitations to partners and configure access controls. Monitor usage and update permissions as needed.
Next Steps
- Review the Analytical Data Sharing FAQ for detailed capabilities and use cases
- Contact Vendia Support for specific questions