--- title: Import SQL into your D1 Database --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api/go) [D1](https://developers.cloudflare.com/api/go/resources/d1) [Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database) Copy Markdown Open in **Claude**Open in **ChatGPT**Open in **Cursor** --- **Copy Markdown****View as Markdown** # Import SQL into your D1 Database client.D1.Database.Import(ctx, databaseID, params) (\*[DatabaseImportResponse](), error) POST/accounts/{account\_id}/d1/database/{database\_id}/import Generate a temporary URL for uploading an SQL file to, then instruct the D1 to import it and poll it for status updates. Imports block the D1 for their duration. ##### Security
API Token The preferred authorization scheme for interacting with the Cloudflare API. Create a token. **Example:**Authorization: Bearer Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY
API Email + API Key The previous authorization scheme for interacting with the Cloudflare API, used in conjunction with a Global API key. **Example:**X-Auth-Email: user@example.com The previous authorization scheme for interacting with the Cloudflare API. When possible, use API tokens instead of Global API keys. **Example:**X-Auth-Key: 144c9defac04969c7bfad8efaa8ea194
##### ParametersExpand Collapse databaseID string D1 database identifier (UUID). [Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20import%20%3E%20(params)%20default%20%3E%20(param)%20database_id%20%3E%20(schema)>)
params DatabaseImportParams AccountID param.Field\[string] Path param: Account identifier tag. maxLength32 Link to this property
Action param.Field\[DatabaseImportParamsInitAction] Body param: Indicates you have a new SQL file to upload. const DatabaseImportParamsInitActionInit DatabaseImportParamsInitAction = "init" Link to this property
Link to this property Etag param.Field\[string] Body param: Required when action is ‘init’ or ‘ingest’. An md5 hash of the file you’re uploading. Used to check if it already exists, and validate its contents before ingesting. Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20import%20%3E%20(params)%200>) ##### ReturnsExpand Collapse
type DatabaseImportResponse struct{…} AtBookmark stringOptional The current time-travel bookmark for your D1, used to poll for updates. Will not change for the duration of the import. Only returned if an import process is currently running or recently finished. Link to this property Error stringOptional Only present when status = ‘error’. Contains the error message that prevented the import from succeeding. Link to this property Filename stringOptional Derived from the database ID and etag, to use in avoiding repeated uploads. Only returned when for the ‘init’ action. Link to this property Messages \[]stringOptional Logs since the last time you polled Link to this property
Result DatabaseImportResponseResultOptional Only present when status = ‘complete’ FinalBookmark stringOptional The time-travel bookmark if you need restore your D1 to directly after the import succeeded. Link to this property
Meta DatabaseImportResponseResultMetaOptional ChangedDB boolOptional Denotes if the database has been altered in some way, like deleting rows. Link to this property Changes float64Optional Rough indication of how many rows were modified by the query, as provided by SQLite’s sqlite3_total_changes(). Link to this property Duration float64Optional The duration of the SQL query execution inside the database. Does not include any network communication. Link to this property LastRowID float64Optional The row ID of the last inserted row in a table with an INTEGER PRIMARY KEY as provided by SQLite. Tables created with WITHOUT ROWID do not populate this. Link to this property RowsRead float64Optional Number of rows read during the SQL query execution, including indices (not all rows are necessarily returned). Link to this property RowsWritten float64Optional Number of rows written during the SQL query execution, including indices. Link to this property ServedByColo stringOptional The three letters airport code of the colo that handled the query. Link to this property ServedByPrimary boolOptional Denotes if the query has been handled by the database primary instance. Link to this property
ServedByRegion DatabaseImportResponseResultMetaServedByRegionOptional Region location hint of the database instance that handled the query. One of the following: const DatabaseImportResponseResultMetaServedByRegionWnam DatabaseImportResponseResultMetaServedByRegion = "WNAM" Link to this property const DatabaseImportResponseResultMetaServedByRegionEnam DatabaseImportResponseResultMetaServedByRegion = "ENAM" Link to this property const DatabaseImportResponseResultMetaServedByRegionWeur DatabaseImportResponseResultMetaServedByRegion = "WEUR" Link to this property const DatabaseImportResponseResultMetaServedByRegionEeur DatabaseImportResponseResultMetaServedByRegion = "EEUR" Link to this property const DatabaseImportResponseResultMetaServedByRegionApac DatabaseImportResponseResultMetaServedByRegion = "APAC" Link to this property const DatabaseImportResponseResultMetaServedByRegionOc DatabaseImportResponseResultMetaServedByRegion = "OC" Link to this property
Link to this property SizeAfter float64Optional Size of the database after the query committed, in bytes. Link to this property
Timings DatabaseImportResponseResultMetaTimingsOptional Various durations for the query. SqlDurationMs float64Optional The duration of the SQL query execution inside the database. Does not include any network communication. Link to this property
Link to this property
Link to this property NumQueries float64Optional The total number of queries that were executed during the import. Link to this property
Link to this property
Status DatabaseImportResponseStatusOptional One of the following: const DatabaseImportResponseStatusComplete DatabaseImportResponseStatus = "complete" Link to this property const DatabaseImportResponseStatusError DatabaseImportResponseStatus = "error" Link to this property
Link to this property Success boolOptional Link to this property Type DatabaseImportResponseTypeOptional Link to this property UploadURL stringOptional The R2 presigned URL to use for uploading. Only returned when for the ‘init’ action. Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(model)%20DatabaseImportResponse%20%3E%20(schema)>) ### Import SQL into your D1 Database Go HTTPTypeScriptPythonGoTerraform ``` package main import ( "context" "fmt" "github.com/cloudflare/cloudflare-go" "github.com/cloudflare/cloudflare-go/d1" "github.com/cloudflare/cloudflare-go/option" ) func main() { client := cloudflare.NewClient( option.WithAPIToken("Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY"), ) response, err := client.D1.Database.Import( context.TODO(), "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", d1.DatabaseImportParams{ AccountID: cloudflare.F("023e105f4ecef8ad9ca31a8372d0c353"), Body: d1.DatabaseImportParamsBodyInit{ Action: cloudflare.F(d1.DatabaseImportParamsBodyInitActionInit), Etag: cloudflare.F("etag"), }, }, ) if err != nil { panic(err.Error()) } fmt.Printf("%+v\n", response.AtBookmark) } ``` 200 example ``` { "errors": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "messages": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "result": { "at_bookmark": "at_bookmark", "error": "error", "filename": "filename", "messages": [ "string" ], "result": { "final_bookmark": "final_bookmark", "meta": { "changed_db": true, "changes": 0, "duration": 0, "last_row_id": 0, "rows_read": 0, "rows_written": 0, "served_by_colo": "LHR", "served_by_primary": true, "served_by_region": "EEUR", "size_after": 0, "timings": { "sql_duration_ms": 0 } }, "num_queries": 0 }, "status": "complete", "success": true, "type": "import", "upload_url": "upload_url" }, "success": true } ``` ##### Returns Examples 200 example ``` { "errors": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "messages": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "result": { "at_bookmark": "at_bookmark", "error": "error", "filename": "filename", "messages": [ "string" ], "result": { "final_bookmark": "final_bookmark", "meta": { "changed_db": true, "changes": 0, "duration": 0, "last_row_id": 0, "rows_read": 0, "rows_written": 0, "served_by_colo": "LHR", "served_by_primary": true, "served_by_region": "EEUR", "size_after": 0, "timings": { "sql_duration_ms": 0 } }, "num_queries": 0 }, "status": "complete", "success": true, "type": "import", "upload_url": "upload_url" }, "success": true } ```