{"id":9061,"date":"2020-08-12T08:42:37","date_gmt":"2020-08-12T15:42:37","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=9061"},"modified":"2025-06-13T20:19:28","modified_gmt":"2025-06-14T03:19:28","slug":"external-datasets-extend-your-reach-with-couchbase-analytics","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/external-datasets-extend-your-reach-with-couchbase-analytics\/","title":{"rendered":"Conjuntos de datos externos: Acceso a AWS S3 en Couchbase Analytics"},"content":{"rendered":"<h3>Introducci\u00f3n a los conjuntos de datos externos<\/h3>\r\n<p>Couchbase se complace en anunciar sus nuevos \"Conjuntos de datos externos\". <a href=\"https:\/\/www.couchbase.com\/blog\/es\/products\/analytics\/\">Servicios anal\u00edticos<\/a> en el \u00faltimo <a href=\"https:\/\/www.couchbase.com\/blog\/es\/whats-new-and-improved-in-couchbase-server-6-6\/\">Lanzamiento de Couchbase Server 6.6<\/a>. Los conjuntos de datos externos permiten a los clientes acceder a datos almacenados externamente en tiempo real desde Amazon Web Services (AWS) Simple Storage Service (S3) y combinar datos residentes en S3 con datos existentes de Couchbase para su an\u00e1lisis.<\/p>\r\n<h3>Caso pr\u00e1ctico del cliente<\/h3>\r\n<p>Algunos clientes utilizan AWS S3 para reducir los costos de almacenamiento y almacenar datos (p. ej., varios a\u00f1os de datos hist\u00f3ricos, datos empresariales sin conexi\u00f3n para aprendizaje autom\u00e1tico, revisiones de productos, etc.). Han expresado su deseo de combinar, consultar y utilizar los datos de S3 en tiempo real para poner estos datos a disposici\u00f3n de los usuarios empresariales para el an\u00e1lisis. <span style=\"font-weight: 400\">M\u00e1s informaci\u00f3n sobre otros casos de uso de Analytics <\/span><span style=\"font-weight: 400\"><a href=\"https:\/\/www.couchbase.com\/blog\/es\/analytics-customer-use-cases\/\">aqu\u00ed<\/a>.<\/span><\/p>\r\n<h3>\u00bfC\u00f3mo funcionan los conjuntos de datos externos?<\/h3>\r\n<p>Los conjuntos de datos externos ofrecen la posibilidad de consultar y analizar din\u00e1micamente datos que residen en AWS S3, lo que permite a los usuarios combinar f\u00e1cilmente datos en tiempo real desde dentro y fuera de sus nodos de an\u00e1lisis de Couchbase. Esto se consigue en tres sencillos pasos:<\/p>\r\n<ol>\r\n<li>Configure un enlace S3 mediante <a href=\"https:\/\/docs.couchbase.com\/server\/6.6\/analytics\/rest-links.html\">Llamada a la API REST<\/a> o el <a href=\"https:\/\/docs.couchbase.com\/server\/6.6\/cli\/cbcli\/couchbase-cli-analytics-link-setup.html\">interfaz de l\u00ednea de comandos (CLI)<\/a><\/li>\r\n<li>Crear un conjunto de datos externo en el enlace S3<\/li>\r\n<li>Consultar el conjunto de datos mediante <a href=\"https:\/\/www.couchbase.com\/blog\/es\/sqlplusplus\/\">SQL<\/a> (o su herramienta BI favorita)<\/li>\r\n<\/ol>\r\n<p>Veamos un ejemplo sencillo. iMaz, una empresa de comercio electr\u00f3nico, vende productos de consumo online. Sus datos de pedidos, productos y usuarios se almacenan en un cl\u00faster de Couchbase con servicios de datos y an\u00e1lisis (en conjuntos separados de nodos del cl\u00faster). Utilizan el servicio Analytics para ejecutar consultas ad hoc y complejas para analizar su negocio. iMaz tambi\u00e9n almacena las rese\u00f1as de sus productos en AWS S3, y les gustar\u00eda combinar y analizar los 3 productos m\u00e1s valorados utilizando el servicio Couchbase Analytics.<\/p>\r\n<p>Muestra de datos del producto:<\/p>\r\n<pre class=\"\">[\r\n{\r\n\"id\": \"Product_1\",\r\n\"docType\": \"Product\",\r\n\"productId\": 1,\r\n\"price\": 811.76,\r\n\"salePrice\": 70.14,\r\n\"productName\": \"Ergonomic Cotton Ball\",\r\n\"desc\": \"Plastic fused metallic Ergonomic Cotton Ball\",\r\n}\r\n]<\/pre>\r\n<p>Muestra de datos de revisi\u00f3n:<\/p>\r\n<pre class=\"\">{\r\n\"id\": \"Review_0001764a17a844279a2227e137cc4e36\",\r\n\"docType\": \"Review\",\r\n\"reviewId\": \"0001764a17a844279a2227e137cc4e36\",\r\n\"productId\": 1,\r\n\"userId\": 5862,\r\n\"reviewerName\": \"M. Schaefer\",\r\n\"reviewerEmail\": \"...@mmail.com\",\r\n\"rating\": 5,\r\n\"title\": \"Works well and meets expectations.\",\r\n\"review\": \"Product works great and will buy one more for my extended family.\",\r\n\"reviewDate\": 1597273484\r\n}<\/pre>\r\n<p>Sigamos los tres pasos anteriores con un ejemplo de c\u00f3digo de configuraci\u00f3n junto con una consulta SQL++.<\/p>\r\n<h4>Paso 1: Configurar el enlace S3<\/h4>\r\n<p>Crearemos un enlace S3 utilizando un archivo <a href=\"https:\/\/docs.couchbase.com\/server\/6.6\/analytics\/rest-links.html\">Llamada a la API REST<\/a>. (Como alternativa, puede utilizar la funci\u00f3n <a href=\"https:\/\/docs.couchbase.com\/server\/6.6\/cli\/cbcli\/couchbase-cli-analytics-link-setup.html\">CLI para crear enlaces S3<\/a>.). Tendremos que proporcionar:<\/p>\r\n<ul>\r\n<li>Nombre de host del servicio de an\u00e1lisis<\/li>\r\n<li>Credenciales de usuario de Analytics<\/li>\r\n<li>Nombre del enlace S3 (en este caso myS3Link)<\/li>\r\n<li>Nombre del dataverse (si es diferente del predeterminado)<\/li>\r\n<li>Tipo de enlace (S3)<\/li>\r\n<li>ID de la clave de acceso requerida de AWS S3<\/li>\r\n<li>Clave de acceso secreta requerida de AWS S3<\/li>\r\n<li>Regi\u00f3n requerida de AWS S3 (por ejemplo, us-west-2)<\/li>\r\n<\/ul>\r\n<pre class=\"decode-attributes:false lang:default decode:true\">curl -u &lt;username&gt;:&lt;pwd&gt;\r\n-X POST \"https:\/\/&lt;analytics_hostname&gt;\/analytics\/link\" \r\n-d dataverse=Default\r\n-d name=myS3Link\r\n-d type=S3\r\n-d accessKeyId=...\r\n-d secretAccessKey=...\r\n-d region=us-west-2<\/pre>\r\n<h4>Paso 2: Crear un conjunto de datos externo<\/h4>\r\n<p>Utilizando el banco de trabajo Analytics, crearemos ahora un conjunto de datos externo denominado \"S3productreviews\". Tendremos que especificar:<\/p>\r\n<ul>\r\n<li>Nombre del bucket S3<\/li>\r\n<li>Nombre del dataverse (si es diferente del predeterminado) y nombre del bucket S3 (en este caso cb-analytics-6.6-demo)<\/li>\r\n<li>Ubicaci\u00f3n del directorio (opcionalmente) dentro del bucket desde el que se leer\u00e1n y recopilar\u00e1n recursivamente los archivos (en este caso, las rese\u00f1as de productos se almacenan en una carpeta \"rese\u00f1as\").<\/li>\r\n<li>Formato de archivo (en este caso utilizaremos JSON) con la posibilidad de especificar un patr\u00f3n de b\u00fasqueda (en este caso *.json indica que se incluir\u00e1n todos los archivos JSON al consultar los datos).<\/li>\r\n<\/ul>\r\n<pre class=\"\">CREATE EXTERNAL DATASET S3productreviews\r\nON cb-analytics-6.6-demo\r\nAT myS3Link\r\nUSING \u201creviews\u201d\r\nWITH { \"format\": \"json\", \"include\": \"*.json\" } ;<\/pre>\r\n<p>En la actualidad, la funci\u00f3n de conjuntos de datos externos admite las funciones <strong>json<\/strong>, <strong>csv <span style=\"font-weight: 400\">(valores separados por comas), y <\/span><b>tsv <\/b><span style=\"font-weight: 400\">(valores separados por tabuladores) <\/span><\/strong>\u00a0incluidos los archivos comprimidos con gzip (los nombres de archivo terminan en .gz o .gzip). Los formatos csv y tsv requieren que se especifique una definici\u00f3n de tipo en l\u00ednea (m\u00e1s informaci\u00f3n al respecto en breve). En futuras versiones se admitir\u00e1n otros formatos de archivo. Puede obtener m\u00e1s informaci\u00f3n al respecto aqu\u00ed.<\/p>\r\n<h4>Paso 3: Consulta con SQL<\/h4>\r\n<p>Como \u00faltimo paso, ahora podemos ejecutar la consulta SQL++ que se indica a continuaci\u00f3n (que tiene exactamente el mismo aspecto que SQL :)). Une el conjunto de datos de productos existentes de Couchbase Analytics Service y los datos de rese\u00f1as de productos de AWS S3 para obtener los 3 productos mejor valorados.<\/p>\r\n<pre class=\"\">SELECT p.productName, AVG(s.rating) AS \u2018Rating\u2019\r\nFROM   S3productreviews s, products p\r\nWHERE  s.productId = p.productId\r\nGROUP\r\nBY.    p.productName\r\nORDER\r\nBY     AVG(s.rating) DESC\r\nLIMIT  3;<\/pre>\r\n<p>Aqu\u00ed est\u00e1n los resultados de la consulta json:<\/p>\r\n<pre class=\"\">[\r\n{ \"Rating\": 4.33, \"productName\": \"Licensed Rubber Tuna\"},\r\n{ \"Rating\": 4.29, \"productName\": \"Gorgeous Plastic Salad\"},\r\n{ \"Rating\": 3.86, \"productName\": \"Intelligent Cotton Bike\"}\r\n]<\/pre>\r\n<p>Esto es genial: ahora podemos combinar y analizar datos externos ubicados en AWS S3 desde Couchbase Analytics Service. F\u00edjate en los pocos pasos que hemos necesitado para poder analizar nuestros datos; no ha sido necesario ning\u00fan ETL, \u00a1y los datos han estado disponibles inmediatamente!<\/p>\r\n<p>Ahora te estar\u00e1s preguntando: \u00bfC\u00f3mo habr\u00eda funcionado esto si el formato del archivo de revisiones de S3 hubiera sido de tipo csv en lugar de JSON? La respuesta es sencilla; simplemente habr\u00eda construido su conjunto de datos externo en consecuencia. A continuaci\u00f3n, mostramos el aspecto que tendr\u00eda la sentencia create external dataset anterior si fuera compatible con csv:<\/p>\r\n<pre class=\"\">CREATE EXTERNAL DATASET S3productreviews\r\n(\r\nid STRING NOT UNKNOWN, \r\ndocType STRING NOT UNKNOWN,\r\nreviewId STRING NOT UNKNOWN,\r\nproductId BIGINT,\r\nuserId BIGINT,\r\nreviewerName STRING NOT UNKNOWN,\r\nreviewerEmail STRING NOT UNKNOWN,\r\nrating BIGINT,\r\ntitle STRING NOT UNKNOWN,\r\nreview STRING NOT UNKNOWN,\r\nreviewDate BIGINT\r\n) \r\nON `cb-analytics-6.6-demo`\r\nAT myS3link\r\nUSING \"reviews\"\r\nWITH { \"format\": \"csv\", \"include\": \"*.csv\", \"header\": false };<\/pre>\r\n<p>Observe c\u00f3mo la sentencia create incluye ahora informaci\u00f3n de tipo en l\u00ednea. Esto es necesario para indicar a Analytics c\u00f3mo interpretar los datos csv (por ejemplo, no s\u00f3lo como cadenas).<\/p>\r\n<p>La consulta SQL++ sigue siendo exactamente la misma. As\u00ed es, \u00a1sin ning\u00fan cambio! Los conjuntos de datos externos son f\u00e1ciles de configurar, flexibles y sencillos de utilizar gracias a la potencia del lenguaje SQL++. Los usuarios pueden desarrollar consultas ad hoc complejas para explorar m\u00e1s a fondo los datos, responder a nuevas preguntas de negocio y combinar datos externos con datos de <a href=\"https:\/\/www.couchbase.com\/blog\/es\/remote-links-analyze-your-enterprise-with-couchbase-analytics\/\">Enlaces remotos<\/a> para traer tambi\u00e9n otras fuentes de datos Couchbase.<\/p>\r\n<h3>Beneficios<\/h3>\r\n<p>Estas son las principales ventajas de utilizar conjuntos de datos externos:<\/p>\r\n<ol>\r\n<li>Enriquecimiento de datos. Los datos de Couchbase ahora se pueden enriquecer con informaci\u00f3n adicional obtenida de archivos que residen en el lago de datos existente basado en S3 de una empresa.<\/li>\r\n<li>Acceso din\u00e1mico a los datos. Los datos m\u00e1s recientes se pueden recuperar, transmitir, combinar y analizar din\u00e1micamente desde cualquier bucket de S3 en cualquier regi\u00f3n de AWS durante la ejecuci\u00f3n de consultas de Analytics.<\/li>\r\n<li>Procesamiento paralelo de consultas. Los usuarios pueden configurar y organizar el acceso a los datos de S3 mediante la arquitectura de procesamiento de consultas en paralelo masivo (MPP) de Analytics para responder con rapidez a las consultas con datos externos.<\/li>\r\n<\/ol>\r\n<h3>Resumen<\/h3>\r\n<p>Los conjuntos de datos externos desbloquean el valor de los datos externos en vivo y archivados que residen en los lagos de datos basados en S3. Los usuarios pueden combinar y analizar datos en tiempo real, procedentes tanto de AWS S3 como de Couchbase Analytics Service. Esto permite un an\u00e1lisis de datos m\u00e1s r\u00e1pido y exhaustivo y una toma de decisiones \u00e1gil.<\/p>\r\n<h3>Recursos<\/h3>\r\n<p>M\u00e1s informaci\u00f3n sobre las declaraciones de los conjuntos de datos externos <a href=\"https:\/\/docs.couchbase.com\/server\/6.6\/analytics\/5_ddl.html\">aqu\u00ed<\/a>. Reg\u00edstrese en <a href=\"https:\/\/event.on24.com\/wcc\/r\/2566405\/9DB74CF2A4251458E10D64B86B68C0EF?partnerref=blog\">aqu\u00ed<\/a> para nuestro pr\u00f3ximo seminario web \"Novedades de la versi\u00f3n 6.6 de Couchbase Server\".<\/p>\r\n<h3>Explorar los recursos de Couchbase Server 6.6<\/h3>\r\n<table width=\"624\">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p><strong>Blogs<\/strong><\/p>\r\n<\/td>\r\n<td>\r\n<p><strong>Documentos y tutoriales<\/strong><\/p>\r\n<\/td>\r\n<td>\r\n<p><strong>P\u00e1ginas web y seminarios web<\/strong><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/whats-new-and-improved-in-couchbase-server-6-6\/\">Novedades de Couchbase Server 6.6<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/introduction\/whats-new.html\">Novedades de Couchbase Server 6.6<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/event.on24.com\/eventRegistration\/EventLobbyServlet?target=reg20.jsp&amp;partnerref=website&amp;eventid=2566405&amp;sessionid=1&amp;key=9DB74CF2A4251458E10D64B86B68C0EF&amp;regTag=&amp;sourcepage=register\">Nuevas funciones de Couchbase Server 6.6: an\u00e1lisis, copias de seguridad, consultas y mucho m\u00e1s<\/a><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/eventing-improvements-timers-handlers-and-statistics\/\">Mejoras en los eventos (temporizadores, controladores y estad\u00edsticas)<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/6.6\/release-notes\/relnotes.html\">Notas de la versi\u00f3n de Couchbase Server 6.6<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/products\/analytics\/\">Servicio de an\u00e1lisis Couchbase<\/a><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/remote-links-analyze-your-enterprise-with-couchbase-analytics\/\">Enlaces remotos - Analice su empresa con Couchbase Analytics<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/index-advisor.couchbase.com\/indexadvisor\/#1\">Pruebe el servicio Couchbase Index Advisor<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/products\/server\/whats-new\/\">Novedades de Couchbase Server (P\u00e1gina del producto)<\/a><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/external-datasets-extend-your-reach-with-couchbase-analytics\/\">Conjuntos de datos externos - Ampl\u00ede su alcance con Couchbase Analytics<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/rest-links.html\">Configuraci\u00f3n de enlaces remotos de Analytics y S3 mediante la API REST<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/products\/editions\/\">Comparar ediciones<\/a><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/announcing-flex-index-with-couchbase\/\">Anuncio de Flex Index con Couchbase<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/5_ddl.html\">Creaci\u00f3n de conjuntos de datos externos mediante el lenguaje de definici\u00f3n de datos (DDL)<\/a><\/p>\r\n<\/td>\r\n<td>\u00a0<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/introducing-backing-up-to-object-store-s3\/\">Introducci\u00f3n a las copias de seguridad en Object Store (S3)<\/a><\/p>\r\n<\/td>\r\n<td>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/cli\/cbcli\/couchbase-cli-analytics-link-setup.html\">Configuraci\u00f3n de enlaces remotos de Analytics y S3 mediante CLI<\/a><\/p>\r\n<\/td>\r\n<td>\u00a0<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/es\/import-documents-with-admin-ui\/\">Importar documentos con Web Admin Console<\/a><\/p>\r\n<\/td>\r\n<td>\u00a0<\/td>\r\n<td>\u00a0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p><em style=\"color: inherit;font-size: 1em;font-weight: 600\">Gracias a Till Westmann como coautor y a Michael Carey por sus valiosas aportaciones y la revisi\u00f3n de este post.<\/em><\/p>\r\n\r\n<div class=\"wp-block-group alignwide has-very-light-gray-background-color has-background\">\r\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\r\n<div class=\"wp-block-media-text alignwide\" style=\"grid-template-columns: 30% auto\">\r\n<figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" class=\"wp-image-9084\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/08\/Till_Westmann-removebg-300px.png\" alt=\"till westman engineering director analytics\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Till_Westmann-removebg-300px.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Till_Westmann-removebg-300px-150x150.png 150w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Till_Westmann-removebg-300px-65x65.png 65w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Till_Westmann-removebg-300px-50x50.png 50w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/Till_Westmann-removebg-300px-20x20.png 20w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\r\n<div class=\"wp-block-media-text__content\">\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p style=\"font-size: 14px\"><strong><em>Coautor<\/em><\/strong><\/p>\r\n\r\n\r\n\r\n<p style=\"font-size: 12px\"><em>Till Westmann, Director de Ingenier\u00eda de Couchbase<\/em><\/p>\r\n\r\n\r\n\r\n<p class=\"has-small-font-size\">Till Westmann es Director de Ingenier\u00eda en Couchbase y trabaja en el Servicio de An\u00e1lisis. Antes de unirse a Couchbase, Till desarroll\u00f3 software de gesti\u00f3n de datos en Oracle, 28msec, SAP, BEA Systems, XQRL y Xyleme. Es miembro de la Apache Software Foundation y Vicepresidente del proyecto Apache AsterixDB. Till es doctor por la Universidad de Mannheim (Alemania).<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Introduction to external datasets Couchbase is very excited to announce its new \u201cExternal Datasets\u201d Analytics Services feature in the latest Couchbase Server 6.6 release. External datasets empower customers to access externally stored data in real-time from Amazon Web Services (AWS) [&hellip;]<\/p>","protected":false},"author":58630,"featured_media":10426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2294,1816,9417,1812],"tags":[1572],"ppma_author":[8967],"class_list":["post-9061","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-couchbase-server","category-performance","category-n1ql-query","tag-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.2 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Accessing AWS S3 with External Datasets in Couchbase Analytics<\/title>\n<meta name=\"description\" content=\"External datasets provide the ability to dynamically query and analyze data residing in AWS S3. Combine data in real-time with Couchbase analytics.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/es\/external-datasets-extend-your-reach-with-couchbase-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"External Datasets: Accessing AWS S3 in Couchbase Analytics\" \/>\n<meta property=\"og:description\" content=\"External datasets provide the ability to dynamically query and analyze data residing in AWS S3. Combine data in real-time with Couchbase analytics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/external-datasets-extend-your-reach-with-couchbase-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-12T15:42:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T03:19:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1588\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Idris Motiwala\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Idris Motiwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/\"},\"author\":{\"name\":\"Idris Motiwala\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\"},\"headline\":\"External Datasets: Accessing AWS S3 in Couchbase Analytics\",\"datePublished\":\"2020-08-12T15:42:37+00:00\",\"dateModified\":\"2025-06-14T03:19:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/\"},\"wordCount\":1164,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png\",\"keywords\":[\"database\"],\"articleSection\":[\"Couchbase Analytics\",\"Couchbase Server\",\"High Performance\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/\",\"name\":\"Accessing AWS S3 with External Datasets in Couchbase Analytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png\",\"datePublished\":\"2020-08-12T15:42:37+00:00\",\"dateModified\":\"2025-06-14T03:19:28+00:00\",\"description\":\"External datasets provide the ability to dynamically query and analyze data residing in AWS S3. Combine data in real-time with Couchbase analytics.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png\",\"width\":1588,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"External Datasets: Accessing AWS S3 in Couchbase Analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\",\"name\":\"Idris Motiwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/28d4b56674680cd3d7fe940321c3e98a\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"caption\":\"Idris Motiwala\"},\"description\":\"Idris is a Principal Product Manager, Analytics at Couchbase with 20+ years experience in design, development and execution of software products at both Fortune 500s and startups leading teams in digital transformation, cloud and analytics. Idris holds an MS in Technology Management and certifications in product management .\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/idrismotiwala\/\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/idris-motiwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Accessing AWS S3 with External Datasets in Couchbase Analytics","description":"Los conjuntos de datos externos ofrecen la posibilidad de consultar y analizar din\u00e1micamente los datos que residen en AWS S3. Combine datos en tiempo real con los an\u00e1lisis de Couchbase.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/es\/external-datasets-extend-your-reach-with-couchbase-analytics\/","og_locale":"es_MX","og_type":"article","og_title":"External Datasets: Accessing AWS S3 in Couchbase Analytics","og_description":"External datasets provide the ability to dynamically query and analyze data residing in AWS S3. Combine data in real-time with Couchbase analytics.","og_url":"https:\/\/www.couchbase.com\/blog\/es\/external-datasets-extend-your-reach-with-couchbase-analytics\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-08-12T15:42:37+00:00","article_modified_time":"2025-06-14T03:19:28+00:00","og_image":[{"width":1588,"height":628,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png","type":"image\/png"}],"author":"Idris Motiwala","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Idris Motiwala","Est. reading time":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/"},"author":{"name":"Idris Motiwala","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8"},"headline":"External Datasets: Accessing AWS S3 in Couchbase Analytics","datePublished":"2020-08-12T15:42:37+00:00","dateModified":"2025-06-14T03:19:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/"},"wordCount":1164,"commentCount":1,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png","keywords":["database"],"articleSection":["Couchbase Analytics","Couchbase Server","High Performance","SQL++ \/ N1QL Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/","url":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/","name":"Accessing AWS S3 with External Datasets in Couchbase Analytics","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png","datePublished":"2020-08-12T15:42:37+00:00","dateModified":"2025-06-14T03:19:28+00:00","description":"Los conjuntos de datos externos ofrecen la posibilidad de consultar y analizar din\u00e1micamente los datos que residen en AWS S3. Combine datos en tiempo real con los an\u00e1lisis de Couchbase.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/08\/external-links-blog-2.png","width":1588,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/external-datasets-extend-your-reach-with-couchbase-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"External Datasets: Accessing AWS S3 in Couchbase Analytics"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8","name":"Idris Motiwala","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/28d4b56674680cd3d7fe940321c3e98a","url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","caption":"Idris Motiwala"},"description":"Idris es Director Principal de Producto, Anal\u00edtica en Couchbase con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o, desarrollo y ejecuci\u00f3n de productos de software tanto en Fortune 500 como en startups liderando equipos en transformaci\u00f3n digital, nube y anal\u00edtica. Idris tiene una Maestr\u00eda en Gesti\u00f3n de Tecnolog\u00eda y certificaciones en gesti\u00f3n de productos .","sameAs":["https:\/\/www.linkedin.com\/in\/idrismotiwala\/"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/idris-motiwala\/"}]}},"authors":[{"term_id":8967,"user_id":58630,"is_guest":0,"slug":"idris-motiwala","display_name":"Idris Motiwala","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","author_category":"","last_name":"Motiwala","first_name":"Idris","job_title":"","user_url":"","description":"Idris es Director Principal de Producto, Anal\u00edtica en Couchbase con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o, desarrollo y ejecuci\u00f3n de productos de software tanto en Fortune 500 como en startups liderando equipos en transformaci\u00f3n digital, nube y anal\u00edtica. Idris tiene una Maestr\u00eda en Gesti\u00f3n de Tecnolog\u00eda y certificaciones en gesti\u00f3n de productos ."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/9061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/58630"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=9061"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/9061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/10426"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=9061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=9061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=9061"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=9061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}