{"id":2367,"date":"2017-12-14T04:25:21","date_gmt":"2017-12-14T04:25:21","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2367"},"modified":"2019-11-22T06:09:49","modified_gmt":"2019-11-22T06:09:49","slug":"import-export-data-amazon-athena-using-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/","title":{"rendered":"Import \/ Export data from Amazon Athena using SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In our previous post we explored unlimited possibilities to call Amazon AWS API using SSIS<\/a>. Now in this post we will learn how to import \/ export data from Amazon Athena\u00a0using SSIS. Amazon Athena is very similar service like Google BigQuery which we documented already<\/a>.\u00a0 To read data from Amazon Athena we will use ZappySys JSON \/ REST API Source<\/a>\u00a0which supports excellent JSON parsing capability like this<\/a>.<\/p>\n

<\/h2>\n

<\/h2>\n

Prerequisites<\/span><\/h2>\n

Before we do hello world demo for calling Amazon AWS API, you will need to make sure following prerequisites are met.<\/p>\n

    \n
  1. SSIS designer installed.\u00a0Sometimes it is referred as BIDS or SSDT (download it from Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  3. Access to valid AWS credentials (Access Key, Secret Key for your IAM User).\u00a0Click here to learn more<\/a>\u00a0about IAM users and Access Key\/Secret Key<\/li>\n
  4. Make sure\u00a0SSIS PowerPack<\/em><\/a>\u00a0is installed.\u00a0Click here to download<\/a>.<\/li>\n<\/ol>\n

    Steps needed to read data from Amazon Athena<\/h2>\n

    To read data from Amazon Athena you need to do atleast 3 steps at very high level. Later on this article we will see each step in depth.<\/p>\n

      \n
    1. Call StartQueryExecution API<\/a> to send SQL Query (Its Job Style API so this call starts Job)<\/li>\n
    2. Keep checking Job Status by calling\u00a0 GetQueryExecution API<\/a> (In the response check State field for Status – We need to look for word SUCCESS)<\/li>\n
    3. Once Job is finished it produces CSV file in S3 Bucket (Output Location is supplied in Step-1)<\/li>\n<\/ol>\n
      \"Read<\/a>

      Read Amazon Athena Query output in SSIS (S3 CSV files)<\/p><\/div>\n

      AWS Console – Athena Query Editor \/ Configure Output Settings<\/h2>\n

      Few things you might have to setup before you can call Athena API in SSIS<\/p>\n

        \n
      1. Make sure your IAM user has correct permission (We used existing policies for ease of use but you can use custom policy for precise permission set)<\/li>\n
      2. Configure default output location for your Athena queries<\/li>\n<\/ol>\n
        \"Configure<\/a>

        Configure IAM user permission to call Amazon Athena API<\/p><\/div>\n

        \"Set<\/a>

        Set Athena Query Output Location<\/p><\/div>\n

        \"Testing<\/a>

        Testing Athena Query inside Amazon AWS Console (Query Editor)<\/p><\/div>\n

        Creating Connection to call Athena API in SSIS<\/h2>\n

        Any API calls made to Amazon Athena service using ZappySys JSON \/ REST API Source<\/a>\u00a0 or \u00a0ZS REST API Task<\/a>\u00a0needs OAuth connection.<\/p>\n

        For REST API Task configure as below (More details about using REST API Task is in the next section).<\/p>\n

          \n
        1. Drag ZS REST API Task from Control Flow Toolbox\"SSIS<\/li>\n
        2. Double click to edit.<\/li>\n
        3. Change Request URL Access Mode to [Url from Connection<\/strong>]<\/li>\n
        4. Now select <<New OAuth Connection>><\/strong> from connection drop down<\/li>\n
        5. On OAuth connection select Amazon AWS API v4<\/strong> as Provider<\/li>\n
        6. Enter your Access Key<\/strong> and Secret Key<\/strong><\/li>\n<\/ol>\n
          Amazon AWS account must have access to Athena API calls and S3 Bucket\u00a0<\/div><\/div>\n
          \"Create<\/a>

          Create SSIS Connection for Amazon AWS API Call (Athena REST API Example)<\/p><\/div>\n

          Creating Table in Amazon Athena using API call<\/h2>\n

          For this demo we assume you have already created sample table in Amazon Athena. If you wish to automate creating amazon athena table using SSIS then you need to call CREATE TABLE<\/a> DDL command using\u00a0ZS REST API Task<\/a>.<\/p>\n

            \n
          1. In the previous ZS REST API Task<\/a>\u00a0select OAuth connection (See previous section)<\/li>\n
          2. Enter Request Url<\/strong> as below
            \n<\/strong><\/p>\n
            https:\/\/athena.us-east-1.amazonaws.com\/<\/pre>\n<\/li>\n
          3. In the HTTP Headers<\/strong> enter below 2 headers\n
            X-Amz-Target: AmazonAthena.StartQueryExecution\r\nContent-Type: application\/x-amz-json-1.1<\/pre>\n<\/li>\n
          4. Change Request method to POST<\/strong><\/li>\n
          5. In the Body enter below\n
            {\r\n \"ResultConfiguration\": {\r\n \"OutputLocation\": \"s3:\/\/my-bucket\/output-files\/\"\r\n },\r\n \"QueryString\": \"create external table tbl01 (CustomerID STRING, CompanyName STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION 's3:\/\/my-bucket\/input-files\/';\",\r\n \"ClientRequestToken\": \"{{System::ExecutionInstanceGUID}}\"\r\n}<\/pre>\n
            Notice:<\/strong> Rather than using hard coded\u00a0 DDL SQL Statement we can use variable placeholder (e.g. “QueryString”: “{{User::Query,FUN_JSONENCODE}}”<\/span>\u00a0\u00a0 ). Use\u00a0FUN_JSONENCODE<\/span>\u00a0to replace new line with \\r\\n else JSON becomes invalid.<\/li>\n
          6. Now click Test Request \/ Response<\/strong>. This will create a new Athena table which we will query in later section.<\/li>\n<\/ol>\n
             <\/p>\n
            Notice that in above Body\u00a0ClientRequestToken is a unique number each time you have to call StartQueryExecution API<\/a>\u00a0to make it simple we used SSIS system variable\u00a0System::ExecutionInstanceGUID<\/strong>. Its unique for each execution. You can also use newid() function from SQL Server and save result to variable if you like.<\/p>\n
            Here is the screenshot of above Request<\/p>\n
            \"RESt<\/a>
            RESt API Task – Create table in Amazon Athena using SSIS (StartQueryExecution API Call)<\/p><\/div>\n
             <\/p>\n
            Uploading data for Amazon Athena (Source files)<\/h2>\n
            Once you have athena table created, we will need some data to query. Loading data to amazon athena table is nothing but upload files to S3. If you noticed we added below line in CREATE TABLE statement in the previous section. This means all source files are located at this S3 location.<\/p>\n
            LOCATION 's3:\/\/my-bucket\/input-files\/'<\/pre>\n
            We have written blog post to explain this process (Click Here – How to load data from SQL server to S3 files<\/a>).<\/p>\n
            Extract data from Amazon Athena using SSIS\u00a0(Query Athena)<\/h2>\n
            Now its time to read some data by writing SQL query for Athena data (i.e. S3 files). As we mentioned earlier, reading data from Athena can be done using following steps.<\/p>\n
              \n
            1. Call\u00a0 StartQueryExecution API<\/a>\u00a0 using REST API Task to execute your Query (It returns you QueryExecutionID). Use same technique as Create Table example. Replace CREATE Table command in body with your SQL Query (New line must be replaced by \\r\\n in JSON).<\/li>\n
            2. Use REST API Task to call\u00a0GetQueryExecution API<\/a>\u00a0and configure periodic status check loop (Task keeps waiting until Success or Failure Value not found in Response)<\/li>\n
            3. Once data is available read data using S3 CSV File Source<\/a><\/li>\n
            4. At last you can clean up query output files or keep it if some other process wants to read it (You can also clean up S3 files using bucket retention policy<\/a> automatically at scheduled interval).<\/li>\n<\/ol>\n
              Now lets see each step in depth<\/p>\n
              Step1-Start Amazon Athena Query Execution<\/h3>\n
              Now first thing is to execute Athena Query by calling\u00a0StartQueryExecution API<\/a>\u00a0. Below steps are almost same steps as we saw in section\u00a0Creating Table in Amazon Athena using API call<\/strong><\/p>\n
              Only part is different here is SQL query is SELECT query rather than CREATE TABLE.<\/p>\n
                \n
              1. Drag and drop\u00a0ZS REST API Task<\/a>\u00a0from SSIS toolbox
                \n\"SSIS<\/li>\n
              2. Enter Request Url<\/strong> as below
                \n<\/strong><\/p>\n
                https:\/\/athena.us-east-1.amazonaws.com\/<\/pre>\n<\/li>\n
              3. In the HTTP Headers<\/strong> enter below 2 headers\n
                X-Amz-Target: AmazonAthena.StartQueryExecution\r\nContent-Type: application\/x-amz-json-1.1<\/pre>\n<\/li>\n
              4. Change Request method to POST<\/strong><\/li>\n
              5. In the Body enter below\n
                {\r\n  \"ResultConfiguration\": {\r\n    \"OutputLocation\": \"s3:\/\/my-bucket\/output-files\/\"\r\n  },\r\n  \"QueryString\": \"select * from sampledb.elb_logs\\r\\nlimit 100000\",\r\n  \"ClientRequestToken\": \"{{System::ExecutionInstanceGUID}}\"\r\n}<\/pre>\n
                Notice:<\/strong> Rather than using hard coded\u00a0 SQL Query we can use variable placeholder (e.g. “QueryString”: “{{User::Query,FUN_JSONENCODE}}”<\/span>\u00a0\u00a0 ). Use\u00a0FUN_JSONENCODE<\/span>\u00a0to replace new line with \\r\\n else JSON becomes invalid.<\/p>\n
                \"RESt<\/a><\/li>\n
              6. Now go to Response Settings<\/strong> Tab and configure below way to extract QueryExecutionId (we will need it later).\n
                Set Extract Type as Json.
                \nEnter Expression as $.QueryExecutionId<\/span>
                \nCheck Save output to Variable and create new Variable (we can name as\u00a0QueryExecutionId )<\/p>\n
              7. That’s it now we can move to next step<\/li>\n<\/ol>\n
                 <\/p>\n
                Step2 – Wait until Athena Query Execution is done<\/h3>\n
                New version of ZS REST API Task includes Status check<\/strong> feature. This feature avoids complex looping logic. Here is how to configure to check Job Status (Wait until Query execution is finished). Steps are almost same as previous section except three things ( Headers, Body and Status Check Tab)<\/p>\n
                For Status check we will call\u00a0GetQueryExecution API<\/a>\u00a0.<\/p>\n
                  \n
                1. Drag and drop\u00a0ZS REST API Task<\/a>\u00a0from SSIS toolbox
                  \n\"SSIS<\/li>\n
                2. Enter Request Url<\/strong> as below
                  \n<\/strong><\/p>\n
                  https:\/\/athena.us-east-1.amazonaws.com\/<\/pre>\n<\/li>\n
                3. In the HTTP Headers<\/strong> enter below 2 headers\n
                  X-Amz-Target: AmazonAthena.GetQueryExecution\r\nContent-Type: application\/x-amz-json-1.1<\/pre>\n<\/li>\n
                4. Change Request method to POST<\/strong><\/li>\n
                5. In the Body<\/strong> enter below\n
                  {\"QueryExecutionId\": \"{{User::QueryExecutionId}}\"}<\/pre>\n
                  Notice:<\/strong>\u00a0Here we have used Variable in the body. This variable we extracted in the previous step. It contains QueryExecution ID for the Job we submitted.<\/p>\n
                  \"SSIS<\/a>
                  SSIS Amazon Athena – Call GetQueryExecution API (Status Check)<\/p><\/div><\/li>\n
                6. Now go to Status Check<\/strong> Tab and configure below way to implement Status check loop. We want to stop check once status is SUCCESS or FAILED or CANCELLED. If we find\u00a0FAILED or CANCELLED in State field then we must fail the step with error.\n
                    \n
                  1. Check Enable Status Check<\/li>\n
                  2. Enter Success Value as SUCCEEDED<\/span><\/li>\n
                  3. Check Fail Task option and enter this regex in the text box\u00a0FAILED|CANCELLED<\/span><\/li>\n
                  4. In the Interval enter 5 seconds delay after each iteration.<\/li>\n<\/ol>\n<\/li>\n
                  5. That’s it. Status check Tab will look like below. Now we can move to next step\n
                    \"REST<\/a>
                    REST API Status check Loop – Keep checking until JOB is done<\/p><\/div><\/li>\n<\/ol>\n
                     <\/p>\n
                    Step3-Read data from Athena Query output files (CSV \/ JSON stored in S3 bucket)<\/h3>\n
                    When you create Athena table you have to specify query output folder and data input location and file format (e.g. CSV, JSON, Avro, ORC, Parquet …) they can be GZip, Snappy Compressed. Once you execute query it generates CSV file. Zappysys can read CSV, TSV or JSON files using S3 CSV File Source<\/a> or S3 JSON File Source<\/a>\u00a0connectors. In this section we will use CSV connector to read Athena output files.<\/p>\n
                    Here is how to Athena output data<\/p>\n
                      \n
                    1. Drag and drop Data flow task from SSIS Toolbox
                      \n\"SSIS<\/li>\n
                    2. Double click data flow and drag and drop\u00a0\u00a0ZS Amazon S3 CSV File Source<\/a>
                      \n\"SSIS<\/li>\n
                    3. Double click to configure it.<\/li>\n
                    4. \u00a0Click New Connection and configure S3 Connection<\/li>\n
                    5. Once connection is created, browse to S3 bucket \/ folder location where Athena outputs files.<\/li>\n
                    6. Replace file name with variable like below\n
                      my-bucket\/output-files\/{{User::QueryExecutionId}}.csv<\/pre>\n
                       <\/li>\n<\/ol>\n
                       <\/p>\n
                      \"Reading<\/a>
                      Reading data from Amazon Athena CSV files (Stored in S3)<\/p><\/div>\n
                      Putting all together – Athena Data Extract Example<\/h2>\n
                      Here is final package with all pieces we talked.<\/p>\n
                      \"Read<\/a><\/p>\n
                       <\/p>\n
                      Conclusion<\/h2>\n
                      You have seen that using ZappySys SSIS PowerPack how quickly you can integrate with Amazon Athena and other AWS Cloud Services.\u00a0\u00a0Download SSIS PowerPack<\/a>\u00a0and try it out by yourself.<\/p>\n
                      Keywords:<\/strong> Extract data from Amazon Athena | Read from Amazon Athena Query file | Import \/ Export data from Amazon Athena | Fetch data from Amazon Athena<\/p>\n","protected":false},"excerpt":{"rendered":"
                      Introduction In our previous post we explored unlimited possibilities to call Amazon AWS API using SSIS. Now in this post we will learn how to import \/ export data from Amazon Athena\u00a0using SSIS. Amazon Athena is very similar service like Google BigQuery which we documented already.\u00a0 To read data from Amazon Athena we will use […]<\/p>\n","protected":false},"author":1,"featured_media":2378,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,99,258,259,181,16,17,205,8,10],"tags":[260,128,6,3,35,12,4],"yoast_head":"\r\nImport \/ Export data from Amazon Athena using SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to integrate Amazon Athena data using SSIS. Import\/Export data using drag & drop. Execute and Read Athena Query output (CSV, JSON) from S3 Bucket.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Import \/ Export data from Amazon Athena using SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to integrate Amazon Athena data using SSIS. Import\/Export data using drag & drop. Execute and Read Athena Query output (CSV, JSON) from S3 Bucket.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-12-14T04:25:21+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-11-22T06:09:49+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"510\" \/>\r\n\t<meta property=\"og:image:height\" content=\"399\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/\",\"name\":\"Import \/ Export data from Amazon Athena using SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png\",\"datePublished\":\"2017-12-14T04:25:21+00:00\",\"dateModified\":\"2019-11-22T06:09:49+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to integrate Amazon Athena data using SSIS. Import\/Export data using drag & drop. Execute and Read Athena Query output (CSV, JSON) from S3 Bucket.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png\",\"width\":510,\"height\":399},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import \/ Export data from Amazon Athena using SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import \/ Export data from Amazon Athena using SSIS | ZappySys Blog","description":"Learn how to integrate Amazon Athena data using SSIS. Import\/Export data using drag & drop. Execute and Read Athena Query output (CSV, JSON) from S3 Bucket.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/","og_locale":"en_US","og_type":"article","og_title":"Import \/ Export data from Amazon Athena using SSIS | ZappySys Blog","og_description":"Learn how to integrate Amazon Athena data using SSIS. Import\/Export data using drag & drop. Execute and Read Athena Query output (CSV, JSON) from S3 Bucket.","og_url":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-12-14T04:25:21+00:00","article_modified_time":"2019-11-22T06:09:49+00:00","og_image":[{"width":510,"height":399,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/","url":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/","name":"Import \/ Export data from Amazon Athena using SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png","datePublished":"2017-12-14T04:25:21+00:00","dateModified":"2019-11-22T06:09:49+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to integrate Amazon Athena data using SSIS. Import\/Export data using drag & drop. Execute and Read Athena Query output (CSV, JSON) from S3 Bucket.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/12\/amazon-athena-integration-logo.png","width":510,"height":399},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/import-export-data-amazon-athena-using-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Import \/ Export data from Amazon Athena using SSIS"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2367"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=2367"}],"version-history":[{"count":10,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2367\/revisions"}],"predecessor-version":[{"id":8366,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2367\/revisions\/8366"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2378"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=2367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=2367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=2367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}