# Extract, Transform, and Load in Go

DevFeed: [Extract, Transform, and Load in Go](<https://devfeed.tech/articles/extract-transform-and-load-in-go-22177.md>)

Original publisher: [Read original article](<https://www.ardanlabs.com/blog/2021/09/extract-transform-load-in-go.html>)

Published: 2021-09-13T00:00:00Z

Content type: tutorial

Language: en

Sources: [William Kennedy](<https://devfeed.tech/sources/william-kennedy.md>)

Topics: [Go Language](<https://devfeed.tech/topics/go-language.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>)

Tags: [ardan-labs](<https://devfeed.tech/tags/ardan-labs.md>), [blog](<https://devfeed.tech/tags/blog.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [download](<https://devfeed.tech/tags/download.md>), [etl](<https://devfeed.tech/tags/etl.md>), [go](<https://devfeed.tech/tags/go.md>), [go-programming](<https://devfeed.tech/tags/go-programming.md>), [golang](<https://devfeed.tech/tags/golang.md>), [grafana](<https://devfeed.tech/tags/grafana.md>), [programming](<https://devfeed.tech/tags/programming.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This tutorial explains extract, transform, and load (ETL) in Go using a food-violations dataset. It covers loading CSV data into an SQL database, querying it, and preparing fields through parsing, renaming, type conversion, and enrichment.

## Source excerpt

Introduction You are about to visit Boston, and would like to taste some good food. You ask your friend who lives there what are good places to eat. They reply with "Everything is good, you can't go wrong". Which makes you think, maybe I should check where not to eat. The data geek in you arises, and you find out that the city of Boson has a dataset of food violations. You download it and decide to have a look.