Description
Extracts the region, state (e.g. USA, Germany) or province (Canada) from a given IPv4 string (dot-decimal notation).Syntax
RegionNameFromIP(ipaddress)
Examples
RegionNameFromIP('69.59.196.211') returns ‘Virginia’.
Getting Started
Packages & Workflows
- ETL: Packages & Workflows Overview
- ETL: Creating a New Package
- ETL: Creating a Workflow
- ETL: Package Designer
- ETL: Creating a Package from a Template
- ETL: Package Creation Guide
- ETL: Creating a Delivery
- ETL: Import or Export Package JSON
- ETL: Package Version Control
- ETL: Component Previewer
- ETL: Dynamic Connections
- ETL: Advanced Search
- ETL: Validating a Package
- ETL: Execute SQL
- ETL: File Mover
- ETL: Run Package
- ETL: PDF to CSV
Sources
- ETL: Sources Overview
- ETL: Amazon Redshift
- ETL: Bing Ads
- ETL: CDC Database
- ETL: Database
- ETL: Facebook Ads Insights
- ETL: File Storage
- ETL: Google Ads
- ETL: Google Analytics
- ETL: Google Analytics 4 (GA4)
- ETL: Google BigQuery
- ETL: Google Cloud Spanner
- ETL: MongoDB
- ETL: NetSuite
- ETL: REST API
- ETL: Salesforce
- ETL: Snowflake
- ETL: Crisp Chat
- ETL: Gmail
- ETL: Google Sheets
- ETL: SharePoint
- ETL: Amazon Athena
- ETL: Amazon RDS
- ETL: Amazon S3
- ETL: DB2
- ETL: Dynamics 365
- ETL: FTPS
- ETL: Google Cloud SQL for MySQL
- ETL: Google Cloud SQL for PostgreSQL
- ETL: Google Cloud Storage
- ETL: Google Drive
- ETL: Gmail
- ETL: Google Sheets
- ETL: HDFS
- ETL: Heroku Postgres
- ETL: HubSpot
- ETL: HubSpot (Service Token)
- ETL: IBM i (AS/400)
- ETL: Instagram
- ETL: Intercom
- ETL: LinkedIn
- ETL: Marketing Cloud (REST)
- ETL: Marketing Cloud (SOAP)
- ETL: Microsoft SQL Server
- ETL: MySQL
- ETL: Oracle
- ETL: PostgreSQL
- ETL: SAP HANA
- ETL: SFTP
- ETL: SFTPToGo
- ETL: SharePoint
- ETL: Shopify
- ETL: TikTok Ads
- ETL: Universal OAuth
- ETL: Xero
- ETL: YouTube
Transformations
- ETL: Transformations Overview
- ETL: Select Transformation
- ETL: Filter Transformation
- ETL: Join Transformation
- ETL: Cross Join Transformation
- ETL: Union Transformation
- ETL: Aggregate Transformation
- ETL: Distinct Transformation
- ETL: Sort Transformation
- ETL: Rank Transformation
- ETL: Window Transformation
- ETL: Limit Transformation
- ETL: Sample Transformation
- ETL: Clone Transformation
- ETL: Assert Transformation
- ETL: Cube Transformation
- ETL: AI Transformation
- ETL: Python Transformation
- ETL: Split Transformation
- ETL: Pivot Transformation
- ETL: Unpivot Transformation
Expressions & Functions
- ETL: Expressions & Functions Overview
- ETL: Functions Reference
- ETL: Using Expressions
- ETL: Using and Setting Variables
- ETL: Global Variables
- ETL: System and Pre-Defined Variables
- ETL: ISO 8601 String Functions
- ETL: Encrypting and Decrypting Data
- ETL: Processing JSON Data
- ETL: Processing XML Data
- ETL: Processing Different Encodings
- ETL: Working with Datetime Data
- ETL: ABS
- ETL: ACOS
- ETL: AddDuration
- ETL: ASIN
- ETL: ATAN
- ETL: BagToString
- ETL: BagToTuple
- ETL: Base64Decode
- ETL: Base64DecodeToString
- ETL: Base64Encode
- ETL: Base64EncodeToString
- ETL: BinaryCCurl
- ETL: BinaryCurl
- ETL: BrowserFamily
- ETL: BrowserFullName
- ETL: BrowserMajor
- ETL: BrowserMinor
- ETL: BrowserPatch
- ETL: BrowserVersion
- ETL: ByteArrayToString
- ETL: CBRT
- ETL: CCurl
- ETL: CCurlPoll
- ETL: CCurlWithPagination
- ETL: CEIL
- ETL: CityNameFromIP
- ETL: ClockTime
- ETL: COALESCE
- ETL: CONCAT
- ETL: ContinentCodeFromIP
- ETL: ContinentNameFromIP
- ETL: COS
- ETL: COSH
- ETL: CountryCodeFromIP
- ETL: CountryNameFromIP
- ETL: CSVSPLIT
- ETL: Curl
- ETL: CurlPoll
- ETL: CCurlWithPagination
- ETL: CurrentTime
- ETL: DateAddDays
- ETL: DateDiffDays
- ETL: DateDiffHours
- ETL: DateDiffMinutes
- ETL: DateDiffMonths
- ETL: DateDiffSeconds
- ETL: DateDiffYears
- ETL: DaysBetween
- ETL: Decrypt
- ETL: DeviceFamily
- ETL: DistInMilesHaversine
- ETL: Encrypt
- ETL: ExecuteBQInsert
- ETL: ExecuteSqlBoolean
- ETL: ExecuteSqlDateTime
- ETL: ExecuteSqlDouble
- ETL: ExecuteSqlFloat
- ETL: ExecuteSqlInt
- ETL: ExecuteSqlLong
- ETL: ExecuteSqlNonQuery
- ETL: ExecuteSqlString
- ETL: EXP
- ETL: ExtractQueryStringParam
- ETL: ExtractSearchQuery
- ETL: ExtractUABrowserID
- ETL: ExtractUABrowserName
- ETL: ExtractUrlPart
- ETL: Flatten
- ETL: FLOOR
- ETL: GetBytes
- ETL: GetDay
- ETL: GetHour
- ETL: GetMilliSecond
- ETL: GetMinute
- ETL: GetMonth
- ETL: GetSecond
- ETL: GetWeek
- ETL: GetWeekYear
- ETL: GetYear
- ETL: HoursBetween
- ETL: INDEXOF
- ETL: IntervalIntersection
- ETL: IsBase64
- ETL: IsEmpty
- ETL: IsISODatetime
- ETL: ISOAddDuration
- ETL: ISODatetimeToString
- ETL: ISODatetimeToTimestampFormat
- ETL: ISOSubtractDuration
- ETL: ISOToDay
- ETL: ISOToHour
- ETL: ISOToMinute
- ETL: ISOToMonth
- ETL: ISOToSecond
- ETL: ISOToWeek
- ETL: ISOToYear
- ETL: JsonExtract
- ETL: JsonExtractScalar
- ETL: JsonStringToBag
- ETL: JsonStringToMap
- ETL: LAST_INDEX_OF
- ETL: LatitudeFromIP
- ETL: LCFIRST
- ETL: Length
- ETL: LOG
- ETL: LOG10
- ETL: LongitudeFromIP
- ETL: LOWER
- ETL: MapToBag
- ETL: MapToQueryString
- ETL: MD2
- ETL: MD5
- ETL: MilliSecondsBetween
- ETL: MinutesBetween
- ETL: MonthsBetween
- ETL: OsFamily
- ETL: OsFullName
- ETL: OsMajor
- ETL: OsMinor
- ETL: OsPatch
- ETL: OsPatchMinor
- ETL: OsVersion
- ETL: ParseDate
- ETL: ParseDoubleOrDefault
- ETL: ParseFloatOrDefault
- ETL: ParseIntOrDefault
- ETL: ParseLongOrDefault
- ETL: PlatformFamily
- ETL: POW
- ETL: QueryStringToMap
- ETL: RANDOM
- ETL: REGEX_EXTRACT
- ETL: REGEX_EXTRACT_ALL
- ETL: REGEX_FIND_ALL
- ETL: RegionCodeFromIP
- ETL: RegionNameFromIP
- ETL: REPLACE
- ETL: Reverse
- ETL: ROUND
- ETL: ROUND_TO
- ETL: SecondsBetween
- ETL: SHA1
- ETL: SHA256
- ETL: SHA256WithRSA
- ETL: SHA384
- ETL: SHA512
- ETL: SIN
- ETL: SINH
- ETL: SIZE
- ETL: Sleep
- ETL: SPRINTF
- ETL: SQRT
- ETL: StringToISODatetime
- ETL: STRSPLIT
- ETL: STRSPLITTOBAG
- ETL: SUBSTRING
- ETL: SubtractDuration
- ETL: SwitchTimeZone
- ETL: TAN
- ETL: TANH
- ETL: TimestampFormatToISODatetime
- ETL: TOBAG
- ETL: ToDate
- ETL: ToDateCustomFormats
- ETL: ToHexString
- ETL: ToJson
- ETL: TOKENIZE
- ETL: TOMAP
- ETL: ToMilliSeconds
- ETL: ToString
- ETL: TOTUPLE
- ETL: ToUnixTime
- ETL: TRIM
- ETL: UCFIRST
- ETL: UPPER
- ETL: URLDecode
- ETL: URLEncode
- ETL: UUID
- ETL: WeeksBetween
- ETL: XPath
- ETL: XPathToBag
- ETL: YearsBetween
Destinations
- ETL: Destinations Overview
- ETL: Amazon Redshift
- ETL: Database
- ETL: Facebook Ads
- ETL: File Storage
- ETL: Google Ads
- ETL: Google BigQuery
- ETL: Google Spanner
- ETL: HubSpot
- ETL: MongoDB
- ETL: NetSuite SOAP
- ETL: Salesforce
- ETL: REST API
- ETL: Snowflake
- ETL: TikTok Ads
- ETL: Google Sheets
- ETL: Azure Blob Storage
- ETL: Azure SQL
- ETL: Azure Synapse Analytics
Scheduling, Jobs & Clusters
- ETL: Scheduling, Jobs & Clusters Overview
- ETL: Running Jobs
- ETL: Scheduling Package Execution
- ETL: Monitoring Jobs
- ETL: Viewing All Jobs in the Account
- ETL: Viewing Completed Task Outputs
- ETL: Viewing Job Error Details
- ETL: Creating a Cluster
- ETL: Editing and Scaling Clusters
- ETL: Monitoring Clusters
- ETL: Terminating a Cluster
Alerts & Monitoring
Security & Access
- ETL: Security & Access Overview
- ETL: Two-Factor Authentication
- ETL: Single Sign-On
- ETL: User Management
- ETL: Managing Account Members
- ETL: Setting Account Member Roles
- ETL: Changing Your Password
- ETL: Password Policy
- ETL: Managing SSH Keys
- ETL: Reverse SSH Tunnel from Windows
- ETL: Firewall Setup
- ETL: IP Allowlist
Functions A to Z
ETL: RegionNameFromIP
Look up and return the region, state, or province name for an IPv4 address. Use REGIONNAMEFROMIP for geographic segmentation in ETL pipelines.
Last modified on April 20, 2026
Was this page helpful?
⌘I
Assistant
Responses are generated using AI and may contain mistakes.