Data Source Connections
      Back to home
      1. Zetaris Support - Knowledge Base
      2. Connecting to Data Sources
      3. Data Source Connections

      AWS S3

      This article covers how to connect Zetaris to AWS S3

      1. Login to the Zetaris platform
      2. Click on NDP fabric builder icon in the navigation located at the top left side of the screen
      3. Click  next to Virtual File Sources to launch the connection dialog.
      4. A pop-up window will appear. Please specify the following values then select Create: 
        1. Database Name
        2. Description
        3. Parameters 
      5. Your new database virtual file source created in step 4 will appear under the virtual file source.
      6. Click next to the new database file source created in the previous step.
         
      7. A pop-up will appear. On Step 1, Choose File store option and then select next.
      8. Upon Step 2 Please provide the following connection details below:
        1. File source: Choose your File Source Type
        2. Storage: Choose Amazon S3 
        3. Table name: Provide any name (without spaces - use underscore)
        4. File path: Provide your s3 path (eg. s3a://zetaris-lightning-test/csv-data/tpc-h/customer.csv)
        5. Access key: Provide your access key
        6. Security key: Provide your security key
        7. Delimiter: “,” ( the delimiter in CSV)
        8. Parameters
          1. header - true
          2. inferSchema - true (Optional)
      9. Once all the details are filled click next to proceed.
      10. Step 3 will provide a table preview of your data. Once satisfied, select Create.
      11. The newly created table will appear under your file source database.
        Capture1
      12. To view the contents of your table click on the preview button preview