Batch Retrieval: Snowflake

Overview:

Banyan will share processed data with you through a secure view. You can access this data directly for analysis.

Steps:

  1. Access Shared Data:

    • Banyan will share a secure view with your account. Query the shared data as follows:
      SELECT * FROM <banyan_shared_view>;
      
  2. Continuous Updates:

    • Banyan is writing files and flushing them every hour or if they have hit XX MBs. This means that data can be updating throughout the day and not all at once. Oftentimes, merchant data comes in batches, so your matches to that data will in essence also be batched.

Actions:

  • Integrate Banyan’s shared data into your analytics workflows using tools like Looker, Tableau, etc.

Credentials & Security

  • Banyan AWS US East Account Locator: GTB18971
  • For other regions or cloud platforms, contact Banyan support.
  • Data is shared securely via direct shares and secure views, ensuring compliance with data privacy standards.