IP Addresses for Import and Export Integrations

You can use the IP addresses in this article to selectively open your firewalls (or public cloud equivalent, such as security groups in AWS) to allow the Treasure Data servers to reach your systems.

  • Data Connector IP addresses
    You whitelist these IP addresses to allow Treasure Data's input integrations to pull data from one of your systems. For example, to ingest data from your MySQL database.
  • Export Integration IP addresses
    You must whitelist the IP addresses that are listed in Export Integrations so that Treasure Data output integrations can push data from a query into one of your systems. For example, a Treasure Data query writes the query result to your MySQL database.

This topic contains:

Tokyo Region Elastic IP Addresses

Import Integrations Export Integrations
52.198.232.201 52.68.7.150
52.198.68.179 52.192.41.224
13.112.195.14 13.230.126.99
52.194.115.251 18.182.248.35
54.249.135.60 52.194.65.171

US Region Elastic IP Addresses

Import Integration Export Integrations
23.21.102.81 54.204.6.216
23.21.103.124 54.221.226.77
23.23.126.184 54.221.228.0
23.23.173.173 54.221.228.51
23.23.88.94 54.221.228.55
50.16.198.121 54.221.228.67
50.16.200.30 54.235.247.100
50.16.223.69 54.243.141.45
54.83.21.182 54.243.183.61
54.83.52.199 54.243.201.254
107.20.134.38 54.243.203.218
107.20.142.104 54.243.203.90
107.20.144.178 54.243.224.39
107.20.145.75 54.243.234.184
107.20.147.58 54.243.31.47
107.20.148.0 54.83.55.51

EU01 Region Elastic IP Addresses

Import Integration Export Integrations
3.120.79.159 35.159.43.93
3.120.50.29 18.197.138.93
3.120.68.15 18.194.191.188

AP02 Region Elastic IP Addresses

Import Integration Export Integrations
52.79.160.42 15.165.146.182
54.180.65.243 15.165.156.3
15.165.210.14 15.164.68.17

S3 Bucket Policy Configuration for Export Integrations

When your S3 bucket is in the same region as your Treasure Data endpoint, you must set a VPC ID to allow TD's access to the bucket and still restrict access.

Region VPC Value
TOKYO vpc-e630c182
US vpc-df7066ba
EU01 vpc-f54e6a9e
AP02 vpc-00ca316f964009497
Copy
Copied
{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "Treasure-Data-eu01-Result-Output",
      "Action": [
        "s3:AbortMultipartUpload",
        "s3:PutObject"
      ],
      "Effect": "Deny",
      "Resource": [
        "arn:aws:s3:::your-bucket",
        "arn:aws:s3:::your-bucket/*"
      ],
      "Condition": {
        "StringNotEqualsIfExists": {
          "aws:sourceVpc": "vpc-f54e6a9e"
        }
      },
      "Principal": "*"
    }
  ]
}

Replace "arn:aws:s3:::your-bucket" and "arn:aws:s3:::your-bucket/*" with your actual S3 bucket's ARN.