<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Teradata Data Science Capabilities - Medium]]></title>
        <description><![CDATA[Updates on Teradata Data Science Capibilites - Medium]]></description>
        <link>https://medium.com/teradata-data-science-capabilities?source=rss----4ee899e6c085---4</link>
        <image>
            <url>https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png</url>
            <title>Teradata Data Science Capabilities - Medium</title>
            <link>https://medium.com/teradata-data-science-capabilities?source=rss----4ee899e6c085---4</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 17:32:05 GMT</lastBuildDate>
        <atom:link href="https://medium.com/feed/teradata-data-science-capabilities" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Intro to Teradata’s R package — tdplyr Part 1]]></title>
            <link>https://medium.com/teradata-data-science-capabilities/intro-to-teradatas-r-package-tdplyr-part-1-834252e89f06?source=rss----4ee899e6c085---4</link>
            <guid isPermaLink="false">https://medium.com/p/834252e89f06</guid>
            <category><![CDATA[r]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[teradata]]></category>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[ai]]></category>
            <dc:creator><![CDATA[Jack McCush]]></dc:creator>
            <pubDate>Mon, 28 Oct 2019 18:49:32 GMT</pubDate>
            <atom:updated>2019-10-28T19:26:20.541Z</atom:updated>
            <content:encoded><![CDATA[<h3>Intro to Teradata’s R package — tdplyr Part 1</h3><h3>Intro</h3><p>tdplyr is Teradata’s Vantage R Client library. tdplyr is a fast, consistent tool for working with data frame like objects within Teradata and it takes advantage of the Big Data and Machine Learning analytics capabilities of Vantage. Teradata in the past few months has made available and published updates to tdplyr on our discussed them on the GitHub <a href="https://github.com/Teradata/tdplyr">site</a></p><h3>Getting Started</h3><p>A good place to start is by checking out this Teradata TechBytes video on Youtube. You can also check out our documentation <a href="https://docs.teradata.com/search/books?filters=prodname~%2522Teradata+R+Package%2522&amp;content-lang=en-US">site</a> for the latest info.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FVjgFWBc2kTM%3Fstart%3D20%26feature%3Doembed%26start%3D20&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DVjgFWBc2kTM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FVjgFWBc2kTM%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/d7b29e57bbceca962339dd71bcfe5a7f/href">https://medium.com/media/d7b29e57bbceca962339dd71bcfe5a7f/href</a></iframe><h3>Installation</h3><p>The Teradata R package (tdplyr) contains proprietary code and cannot be offered on CRAN. It is available from Teradata’s R package repository, run the following script to download and install in your R environment.</p><pre>Rscript -e &quot;install.packages(&#39;tdplyr&#39;,repos=c(&#39;https://teradata-download.s3.amazonaws.com&#39;,&#39;https://cloud.r-project.org&#39;))&quot;</pre><p>The above command also installs the package dependencies dplyr, dbplyr, DBI, magrittr and teradatasql packages which are available from CRAN or Teradata’s R package repository.</p><h3>Some Background</h3><p>In the latest release, we are recommending using <a href="https://github.com/Teradata/r-driver"><em>Teradata SQL Driver for R</em></a><em> </em>over the ODBC driver. The driver is maintained in a separate package teradatasql. The new driver implements the <a href="https://dbi.r-dbi.org/">DBI Specification</a> and moves us in a more flexible direction with respect to R applications interacting with Vantage. Some features I am very excited about include support for more data types and <a href="https://github.com/Teradata/r-driver#DataTypes">enhanced data type mappings</a> and an interface to <a href="https://github.com/Teradata/r-driver#FastLoad">FastLoad</a> as well as <a href="https://github.com/Teradata/r-driver#StoredPasswordProtection">password encryption</a>. At the time of publication, FastExport is not supported, but it is on the roadmap.</p><h3>Connecting to Vantage</h3><p>While there are a few ways to connect the easiest is to use the native driver.</p><pre>library(tdplyr) <br># Create context using the Teradata Native Driver.<br> <br>con &lt;- td_create_context(host = <em>&lt;host-name&gt;</em>, uid=<em>&lt;username&gt;</em>, pwd=<em>&lt;password&gt;</em>, dType = &quot;native&quot;)</pre><p>We know data scientists often get access to data files from various sources. wanted to make it easier for you to move them from the client-side to Vantage. This example uses the copy_to() function to create a table named “iris_flowers” in the “TDUserDB” database of Vantage. The table contains the same data as the “iris” dataset and can be manipulated using Vantage commands.</p><pre>copy_to(con, iris, name=&quot;iris_flowers&quot;, overwrite=FALSE)</pre><p>copy_to() function will work for small datasets if you are wanting to copy a larger dataset (&gt; 100,000 rows) it would be best to use the FastLoad protocol. Here is an <a href="https://github.com/Teradata/r-driver/blob/master/samples/fastloadbatch.R">example</a> on to use FastLoad to load a large file into Teradata Vantage with R.</p><h3>Interacting with tables</h3><p>Once you have a connection to a Teradata Vantage system you can create virtual dataframes using tbl() command. The result is a tdplyr tibble object referencing an existing table in a Teradata Vantant system.</p><p>The following command creates a tdplyr tibble object “tddf_iris” from the existing table “iris_flowers” in Vantage.</p><pre>tddf_iris &lt;- tbl(con, &quot;iris_flowers&quot;)</pre><p>You can create a tibble of a table from your non-default database by using the in_schema() command.</p><pre>itddf_iris &lt;- tbl(con, in_schema(&quot;diff_database&quot;, &quot;iris_flowers&quot;))</pre><h3>dplyr-like Verbs</h3><p>We are still expanding tdplyr for support of more dplyr capabilities. Here is a list of the current dplyr-like verbs for release 16.20.00.04.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5eTgbu9e60q73NCcHL_snQ.png" /></figure><p>In the next post, I will give some examples of the usage of dplyr-like functionality.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=834252e89f06" width="1" height="1" alt=""><hr><p><a href="https://medium.com/teradata-data-science-capabilities/intro-to-teradatas-r-package-tdplyr-part-1-834252e89f06">Intro to Teradata’s R package — tdplyr Part 1</a> was originally published in <a href="https://medium.com/teradata-data-science-capabilities">Teradata Data Science Capabilities</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>