--- title: Automated Snowpipe Setup with Snowflake CoCo Is Now GA description: Snowflake has made automated Snowpipe setup with Snowflake CoCo generally available. It lets teams go from raw files in cloud storage to a continuously loading... canonical: https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Automated Snowpipe Setup with Snowflake CoCo Is Now GA | daily.dev og:description: Snowflake has made automated Snowpipe setup with Snowflake CoCo generally available. It lets teams go from raw files in cloud storage to a continuously loading... og:url: https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv og:image: https://api.daily.dev/og/posts/K0PD3BORV.png og:image:alt: Automated Snowpipe Setup with Snowflake CoCo Is Now GA og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Automated Snowpipe Setup with Snowflake CoCo Is Now GA **[Snowflake](https://daily.dev/sources/snowflake)** · 9 min read · 0 upvotes · 0 comments ## Summary Snowflake has made automated Snowpipe setup with Snowflake CoCo generally available. It lets teams go from raw files in cloud storage to a continuously loading Snowflake or Iceberg table through a single natural-language conversation. CoCo samples files, infers the schema, builds the pipeline and confirms data loads correctly. On AWS, it uses time-limited IAM temporary delegation instead of shared access keys, and it can generate Terraform for the whole pipeline. CoCo also offers to load the last seven days of files right away, and can run a one-time load for older files. Bulk loading with CoCo, for one-time loads like backfills or migrations, is generally available too. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How does Snowflake CoCo set up Snowpipe without sharing AWS access keys? It uses AWS IAM temporary delegation, where you approve a one-time, time-limited permissions request in the AWS Management Console. Snowflake then creates the storage role, trust policy and bucket notifications itself, and AWS CloudTrail logs every setup action taken under that delegated role, so no long-lived AWS access keys are ever shared. _Teams wiring up cloud pipelines can track access-control approaches like this one on daily.dev._ ### Can Snowpipe load data into an Apache Iceberg table instead of a standard Snowflake table? Yes, Snowflake CoCo can set up a Snowflake-managed Iceberg table along with the pipe that feeds it. Snowpipe writes the data as Parquet, converting other formats during load, and Snowflake maintains the Iceberg metadata so Spark and other Iceberg-compatible engines can read the same table, with Snowflake also handling table maintenance. _Anyone choosing between Snowflake-native and Iceberg table formats can follow pipeline design updates like this on daily.dev._ ### Does Snowflake CoCo automatically backfill files that arrived before a Snowpipe was created? Yes, it offers to load the last seven days of files right away and can run a one-time load for anything older, so files that landed before the pipe existed are not left behind. If new fields start appearing in the source, CoCo can also enable schema evolution to add them as new columns, asking first on an existing table. _Engineers backfilling pipelines can keep up with data-loading automation like this via daily.dev._ ## Similar posts on daily.dev - [Introducing CocoPlus: A Structured Way to Build with Snowflake CoCo](https://daily.dev/posts/introducing-cocoplus-a-structured-way-to-build-with-snowflake-coco-zha3xzwz9) · Snowflake Community · 0 upvotes · 0 comments - [Governed AI for Every Builder: Enterprise Controls in Snowflake CoCo](https://daily.dev/posts/governed-ai-for-every-builder-enterprise-controls-in-snowflake-coco-uk5mcnnud) · Snowflake · 0 upvotes · 0 comments - [Snowflake CoCo for the Power BI Practitioner](https://daily.dev/posts/snowflake-coco-for-the-power-bi-practitioner-6slkt8mec) · Snowflake Community · 0 upvotes · 0 comments - [Snowflake CoCo and CoWork: Governed Context for Agentic AI](https://daily.dev/posts/snowflake-coco-and-cowork-governed-context-for-agentic-ai-uapc0ap69) · Decube · 0 upvotes · 0 comments --- Tags: [#aws](https://daily.dev/tags/aws), [#data-engineering](https://daily.dev/tags/data-engineering), [#snowflake](https://daily.dev/tags/snowflake), [#apache-iceberg](https://daily.dev/tags/apache-iceberg) [View this post on daily.dev](https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Automated Snowpipe Setup with Snowflake CoCo Is Now GA","url":"https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv"},"datePublished":"2026-10-29T11:37:46.566Z","dateModified":"2026-10-29T11:38:14.966Z","description":"Snowflake has made automated Snowpipe setup with Snowflake CoCo generally available. It lets teams go from raw files in cloud storage to a continuously loading...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/abf5ec667266dd5ef174213ba21fa892?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/abf5ec667266dd5ef174213ba21fa892?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Snowflake","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Snowflake","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/fd3e7ffcdf2c438db701a0c6b34281ca","url":"https://daily.dev/sources/snowflake"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"aws,data-engineering,snowflake,apache-iceberg","timeRequired":"PT9M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Snowflake","item":"https://daily.dev/sources/snowflake"},{"@type":"ListItem","position":3,"name":"Automated Snowpipe Setup with Snowflake CoCo Is Now GA"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/automated-snowpipe-setup-with-snowflake-coco-is-now-ga-k0pd3borv#faq","mainEntity":[{"@type":"Question","name":"How does Snowflake CoCo set up Snowpipe without sharing AWS access keys?","acceptedAnswer":{"@type":"Answer","text":"It uses AWS IAM temporary delegation, where you approve a one-time, time-limited permissions request in the AWS Management Console. Snowflake then creates the storage role, trust policy and bucket notifications itself, and AWS CloudTrail logs every setup action taken under that delegated role, so no long-lived AWS access keys are ever shared. Teams wiring up cloud pipelines can track access-control approaches like this one on daily.dev."}},{"@type":"Question","name":"Can Snowpipe load data into an Apache Iceberg table instead of a standard Snowflake table?","acceptedAnswer":{"@type":"Answer","text":"Yes, Snowflake CoCo can set up a Snowflake-managed Iceberg table along with the pipe that feeds it. Snowpipe writes the data as Parquet, converting other formats during load, and Snowflake maintains the Iceberg metadata so Spark and other Iceberg-compatible engines can read the same table, with Snowflake also handling table maintenance. Anyone choosing between Snowflake-native and Iceberg table formats can follow pipeline design updates like this on daily.dev."}},{"@type":"Question","name":"Does Snowflake CoCo automatically backfill files that arrived before a Snowpipe was created?","acceptedAnswer":{"@type":"Answer","text":"Yes, it offers to load the last seven days of files right away and can run a one-time load for anything older, so files that landed before the pipe existed are not left behind. If new fields start appearing in the source, CoCo can also enable schema evolution to add them as new columns, asking first on an existing table. Engineers backfilling pipelines can keep up with data-loading automation like this via daily.dev."}}]} ```