Similar to Windows, macOS utilizes named data sources (DSNs) for connecting ODBC-based client applications to Snowflake.

In this Topic:

Snowflakes is a little application that puts the beautiful sight of falling snow on your Mac's screen while you work. Very small - less than 200k. As a novelty item, it is not yet really optimized, so don't run this at the same time you need all of your CPU power! Have fun with this. Home Old Applications for Mac OS X 10.6 (Snow Leopard) (Intel) Messengers. Adium for Mac (13) AIM for Mac (1) ICQ for Mac (1) Yahoo Messenger for Mac (4) Skype for Mac (19) MSN Messenger for Mac (1) View All. UTorrent for Mac (25) FrostWire for Mac (45) Azureus for Mac (7).


Operating System¶

For a list of the operating systems supported by Snowflake clients, see Operating System Support.


The Snowflake ODBC driver for Mac requires iODBC, which is available for download from:

To install iODBC:

  1. After downloading iODBC, double-click on the downloaded .dmg file.

  2. Double-click on the installer file, iODBC-SDK.pkg, and follow the prompts.


iODBC provides a GUI administrator tool for configuring drivers and DSNs; however, this tool has not been tested for use with Snowflake and, therefore, should not be used to create or manage DSNs. Use ODBC Manager instead.

ODBC Manager — Optional/Recommended

ODBC Manager is a GUI tool for configuring drivers and creating/managing DSNs. The tool is optional because you can also create DSNs manually by editing the appropriate odbc.ini file. ODBC Manager is available from:

To install ODBC Manager:

  1. After downloading ODBC Manager, double-click on the downloaded .dmg file.

  2. Double-click on the installer file, ODBCManager.pkg, and follow the prompts.

The installer installs ODBC Manager in the ~/Applications/Utilities directory.

Step 1: Install the ODBC Driver¶

To install the Snowflake ODBC driver for macOS:

  1. If you haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver.

  2. Double-click on the downloaded .dmg file, snowflake_odbc_mac-<version>.dmg.

  3. Double-click on the installer file, snowflakeODBC_<version>.pkg, and follow the prompts.

    You will likely be prompted for the administrator/sudo password for the machine on which you are installing the driver.

If you choose the default directory when prompted, the installer installs the ODBC driver files in the following directories:

Step 2: Configure the ODBC Driver¶

To configure the ODBC driver for macOS, create one or more data source (DSNs), which are stored in the following files, depending on the type of DSN you create:

  • User DSNs: ~/Library/ODBC/odbc.ini

  • System DSNs: /Library/ODBC/odbc.ini

To create a DSN, either use ODBC Manager or edit the appropriate odbc.ini file.

Creating a DSN Using ODBC Manager¶

To create a DSN in ODBC Manager:

  1. Start ODBC Manager.

  2. Click on User DSN or System DSN.

  3. Click the Add button.

  4. Select the driver to use (Snowflake) and click OK.

  5. Enter the name of the DSN and optionally a description.

  6. Create a Keyword/Value pair for each DSN parameter:

    1. Click Add to create a Keyword/Value pair.

    2. Select Keyword and replace it with the parameter name.

    3. Select Value and replace it with the value for the parameter.

    Repeat this process for each parameter. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters.

  7. Click OK to create the DSN.

If you are creating the first user or system DSN for the ODBC driver, ODBC Manager creates the odbc.ini file in the corresponding directory for the type of DSN you are creating. If you are creating additional DSNs, ODBC Manageradds entries for each DSN to the existing odbc.ini file.

Creating a DSN by Adding an Entry in the odbc.ini File¶

If a user or system DSN has already been created for the driver, add the new entry to the odbc.ini file that already exists in the corresponding directory for the type of DSN you are creating. If you are creating the first DSNfor the driver, you must manually create the odbc.ini file and add the entry to the file.

For each DSN, specify:

  • DSN name and driver name (Snowflake), in the form of <dsn_name>=<driver_name>.

  • Directory path and name of the driver file, in the form of Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib.

  • Connection parameters, such as server and uid (user login name). Any connection parameters you add to the DSN do not need to be specified in the ODBC connect string.

  • Any additional parameters, such as default role, database, and warehouse.

Parameters are specified in the form of <parameter_name>=<value>. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters.

The following example illustrates an odbc.ini file containing two drivers, testodbc1 for account xy12345 (located in the AWS US West region) and testodbc2 for account yz23456(located in the AWS US East region):

Note the following:

  • Both testodbc1 and testodbc2 have default roles.

  • testodbc2 also has a default database and warehouse.

Step 3: Test the ODBC Driver¶

You can use the iodbctest command line utility provided with iODBC to test the DSNs you create.

When prompted for the ODBC connect string, enter the required connection parameters (DSN name, server, user login name, and password), as well as any other parameters that you would like to enter as part of the connect string. Theconnect string takes parameters in the form of <parameter_name>=<value>, e.g. dsn=testodbc2, with each parameter separated by a semi-colon (;) and no blank spaces. For the list of supported parameters, seeODBC Configuration and Connection Parameters.


Snowflakes Macro

If you set the server and user login name in the DSN, the only required parameters in the connect string are the DSN name and user password.

For example:


I’m Randy Ingermanson, known around the world as “the Snowflake Guy” in honor of my “Snowflake method” for designing and analyzing novels. I’ve written six award-winning novels. Before those, I wrote a few that never got published. Each story was tough to write. But the later novels were a LOT easier than the earlier ones.

Why? Because one day I realized it was simpler to design my storylines and create my characters BEFORE I wrote my novels. That way, I was able to spend more of my writing time being creative and less of my writing time worrying about whether it was all going to fit together into a cohesive design.

Years ago, I put my ideas together into an organizational tool I call the “Snowflake method”. That has become the most popular page on my web site and has been viewed over six million times. The Snowflake method is used by novelists all over the world.

If you want to know what people say about the Snowflake method, Google “Snowflake method.”You’ll find that some people love it and some don’t. That’s because different people are different, which is fine by me. The important point is that zillions of people around the world use the Snowflake method, including a number of published authors.

A Challenge To Work Hard

The bad news is that the Snowflake method makes you work. Let’s not fool ourselves that writing fiction is easy. If it were, everybody would be writing great fiction. Writing a novel is hard. The Snowflake method helps you organize your ideas, but it also makes you work. Hard.

The Snowflake method has ten steps that include a high-concept story idea, a Three-Act Structure, a detailed character analysis, a synopsis, a scene list, and more. That’s some serious thinking you need to do.

The good news is that I’ve written software to make it simple and fun to work through the first nine steps of the Snowflake method (everything but step 10, writing the actual first draft–you can already do that in any word processor). I’ve got more than thirty years of experience writing software. So I wrote a program, Snowflake Pro, to make the steps of working through the Snowflake method a joy — at least for me.

I added in four examples of Snowflake analyses of popular books and movies. (I’d like to thank my daughter Carolyn, who has a degree in English Literature, for helping me write these four example Snowflakes.) They’re all included in Snowflake Pro:

  • Gone With the Wind
  • Harry Potter and the Sorcerer’s Stone
  • Pirates of the Caribbean
  • Pride and Prejudice

Seeing the Big Picture

Many writers have a hard time explaining their story to agents or editors. The Snowflake method asks you to define a one-sentence summary and then expand that to a Three-Act Structure. That takes some thinking. It forces you to really understand your own story.

Understanding Your Characters

Several of the steps in the Snowflake method ask you to define your characters and then to get to know them — really well. This pays huge dividends in your fiction writing. The better you understand your characters, the more real they’ll seem to your readers.

Lining Up Your Scenes

A modern novel has dozens of scenes — often more than a hundred. Managing all those scenes is hard, because they cover hundreds of pages in your manuscript. A Scene List allows you to see all your scenes at a glance. Snowflake Pro makes it easy to create and edit your Scene List. You can import your scenes directly from your synopsis, edit scenes, move them around, add new scenes, delete scenes that aren’t working, and estimate the page count of your story. And a whole lot more.

Creating a Proposal — At The Press of a Button!

Many editors and agents insist on receiving a book proposal for your novel. There’s nothing complicated about a proposal. It spells out a suggested business partnership between you and a potential publisher, explaining the risks and rewards of publishing your novel.

The good news? Many of the pieces of a book proposal are actually steps in the Snowflake method.

So I added a bonus step in Snowflake Pro. This is not part of the Snowflake method; it’s just a little goodie that I threw in as an extra feature because I had all the information needed:

At the press of a button, Snowflake Pro will write the skeleton of a book proposal for your novel. If you do all of the first six steps in the Snowflake method, they’ll all go straight into the correct places in your proposal. If you skip steps, that’s OK — Snowflake Pro will leave empty slots in your proposal, with directions on how to fill them in.

Snowflake Pro will also write in empty slots for things like your market analysis and marketing plan which are NOT part of the Snowflake method — along with some savvy suggestions on how to fill in these essential parts.

Just press that button and Snowflake Pro will save your proposal skeleton as an RTF file on your hard drive — ready for you to load into any word processor, where you can then fill in all the details. (RTF files are universal. All word processors can read them.)


If you’ve ever tried to write a book proposal, you know that the hardest part is just getting started. What should go in and what shouldn’t? How do you format it? How do you know if you’re doing it right?

Don’t be paralyzed by uncertainty. I love writing proposals. I’ve written many. One of my former editors teaches “how to write a proposal” at conferences all the time, using an old proposal that I sold to him years ago.

Use Snowflake Pro to get a running start on your proposal. And then use all the handy tips Snowflake Pro embeds in the proposal to guide you in polishing it to a high sheen.

Your License

When you buy Snowflake Pro, you buy a license to run it on up to five of your own personal machines. For example, if you have a laptop and a desktop computer and you own other computers that your spouse and kids use, you are licensed to install and run Snowflake Pro on all of them. Yes, really. That’s a very permissive license. In exchange for that, I ask that you not pirate Snowflake Pro. I try to do the right thing by you; thanks in advance for doing the right thing by me.

Will Snowflake Pro Run On Your Computer?

I wrote Snowflake Pro in a language called Java, which runs on ANY modern laptop or desktop computer running Mac or Windows. If your computer was new within the last ten years or so, you should be able to just download Snowflake Pro, install it, and run it. I’ve worked hard with my team of testers to make the whole process as simple and error-free as we can. See the System Requirements below.

System Requirements: 15 MB of hard drive space. Java version 1.8 or later.


(Java comes installed on most modern computers. If it’s not pre-installed on your machine, you can get Java FREE at the official Java web site here.) Here are the systems my team of testers have tested Snowflake Pro on:

  • On Windows XP, Windows Vista, Windows 7, Windows 8, or Windows 10, you’re good.
  • On a Mac, (any version of Mac OS, including the latest, Catalina), you’re good.
  • On Linux, (there are a zillion flavors of Linux, and Java runs on all of them), you should be good, but I can’t really test on all possible variations of Linux.

Please note that tablets and phones are not laptops or desktop computers. Snowflake Pro does not run on an iPad, iPod, iPhone, Blackberry, or Android device.

Here’s What You Get in Snowflake Pro

Here are some of the key things you get in Snowflake Pro:

  • An easy form to work through each of the key steps of the Snowflake method:
    • Your one-sentence storyline. This is your most powerful selling tool for selling your book.
    • Your one-paragraph summary. If somebody asks about your “Three-Act Structure,” this is it in one paragraph. Memorize it before you talk to editors or agents.
    • Your character key info. Each character’s storygoals, ambition, epiphany, and other crucial information. If you don’t understand your characters, odds are it’s because you haven’t asked yourself the right questions yet.
    • A one-page synopsis. Grow this naturally from your one-paragraph summary. This is your baseline for creating the synopsis you’ll need for your editor someday.
    • Character sketches. These are terrific for inserting straight into a proposal because editors love character-oriented fiction.
    • A four-page synopsis. Grow this out from your one-page synopsis. With this in hand, you’ll know all the important turns in your story.
    • Character bibles. This is where you save all those pesky details you need to write three-dimensional characters. Take care of the details and your characters will take care of you.
    • A scene list. You can get this rolling by importing one of your synopses, then tweak it so you have an overview of every scene in your novel. This makes rearranging scenes in your novel a breeze. Includes a word-count projection so you always can estimate how long your novel will be.
    • Scene details. Any stray information that you need for each scene goes here. Don’t lose that info! Put it where you can’t miss it.
  • Audio help on each stage of the Snowflake. If you’re an audio learner, this will help lock it into your memory.
  • Text help on each stage of the Snowflake. If you need to see the words, this is for you.
  • Four example Snowflakes to show you how it’s done:
    • Gone With The Wind
    • Harry Potter and the Sorcerer’s Stone
    • Pirates of the Caribbean
    • Pride and Prejudice
  • A button to create the skeleton of your proposal. Click that button, and Snowflake Pro will write an RTF file that contains the core of a proposal. Don’t be paralyzed by doubt about how to write a proposal.
  • The accumulated wisdom of 30+ years of a published novelist. I’ve published six novels. I’ve won about a dozen awards. The Snowflake method contains what I believe to be core to writing fiction. I have no patience for the fluff, so I left that out.

How Much Does It Cost?

When I first created Snowflake Pro, I looked at various software tools for novelists in software review articles in Writer’s Digest. The trend was clear: The simple tools were free or very inexpensive. The complicated programs tended to be very pricey — hundreds of dollars.

I thought hard about those tools and their prices. I didn’t want to make Snowflake Pro too expensive, because I wanted to give you good value for your money. But I also didn’t want to price it too low, because I believed that people don’t value things that they get too cheap. I wanted my fans to value Snowflake Pro enough to use it.

Based on those thoughts, when I launched Snowflake Pro, I set the price at $100. That was and still is a fair price. I also have offered for a long time a 50% discount for those people who own a copy of my book How to Write a Novel Using the Snowflake Method.

But after running a store for ten years, things have changed for me. I’ve recently updated Snowflake Pro to run correctly on the latest version of Mac OS. I’ve added in an autosave feature. I’ve added the ability to drag scenes around. But the fact is that I don’t really like the administrative hassle of running my own store and dealing with constant requests for people who bought the software many years ago and now want another download because their hard drive crashed. It’s hard to automate those kind of requests. So that’s why I’ve made a fairly radical decision …

Snowflake Pro is Currently Free (With a Caveat)

As of December, 2019, Snowflake Pro is no longer for sale at any price. That means, I don’t have to run a store anymore and I can simplify my life.

Instead of selling Snowflake Pro, I’ve made it available as a free download if either of the following is true:

  • You previously bought a paid copy of Snowflake Pro.


  • You own a copy of my book How to Write a Novel Using the Snowflake Method.

What’s the catch? There is no catch. You get a $100 product for free. I don’t have to deal with the admin stuff anymore. That’s a win-win, right?

But how will I make money? That’s easy. I have plenty of books I want to write and (possibly) some teaching tools I want to create. I need my time and energy back, so I can work on new stuff. Don’t worry, I’ll make plenty of money from those. Snowflake Pro has been very good for my customers and very good for me, but I just don’t want to run a software company anymore. I have other fish to fry.

Will I do any more updates on Snowflake Pro? Maybe. Or maybe not. I use it myself, so if I need it to work better, I’ll tweak it and issue an update. I may possibly sell the product to somebody who wants to run a software company. Or I might license it to them. If that happens, of course they’ll sell the product, and at that point, I’ll no longer give it away for free. But right now, Snowflake Pro is my toy, and I can give away if I want to.

Get Snowflake Pro In 30 Seconds

Snowflake Pro is available for immediate download. It should normally download in less than 30 seconds if you have a decent internet connection. Get it now!

Please remember that Snowflake Pro is ONLY available as a download, NOT as a CD. This is pretty standard these days, but I still occasionally get an email asking for a CD option. There isn’t one.

Snowflakes Macrame

Please remember that if you have some glitch in downloading or installing Snowflake Pro, the problem is most often a problem with Java. Most of my customers don’t have any problems at all, but if you hit a snag, please make sure that the latest version of Java is installed on your system. It’s free and you can get it at the official Java web site. If that doesn’t solve your problem, send me an e-mail from my Contact page and I’ll do my best to get you squared away as fast as possible.

How To Get Snowflake Pro

If you already bought an earlier version of Snowflake Pro, then hop on over to my Download Again page.

If you already own my book How to Write a Novel Using the Snowflake Method, then you can also download Snowflake Pro for free on my Download Again page. You can get the paper version of my book for less than $12 and the e-book version costs $5.99. And there’s also an audiobook version available.

Why would I give you such an outrageously good deal? As I already explained above, I’m done with running a store and a software company. I’m moving on to other challenges, but the software still works fine, and lots of my fans want it. So have at it, and have fun!

Where to buy the book:

Here are some online places you can buy How to Write a Novel Using the Snowflake Method:

  • Amazon (paper, e-book, or audiobook) (Audiobook is free if you sign up for an Audible subscription)
  • Audible (audiobook only) (Free if you sign up for an Audible subscription)
  • Barnes & Noble (paper or e-book)
  • iBooks (e-book only) or iTunes (audiobook only)
  • Kobo (e-book only)
  • Smashwords (e-book only)

Snowflake For Machine Learning


To go to the download page for Snowflake Pro, click the button below:

Snowflake for machine learning

Snowflakes For Machine Embroidery


Snowflakes Formation Video

I’d like to thank my team of Alpha Testers who helped me test the downloading, installation, and running of Snowflake Pro on a wide variety of computer systems. In alphabetical order, they are: Rick Acker, Tom Adshead, Bryce Beattie, Sven Bergner, Jeannie Campbell, Phil Conrad, Sean Dare, Peter Economy, Meredith Efken, Dale Emery, Jorg-Peter Friederich, Lynne Gentry, Tim Greene, Jeff Hilton, Jim Huskins, Chris Kirkby, Tosca Lee, Steve Lewis, Ken Marable, Alastair Mayer, Colleen Peterson, Srey Seng, Lynetta Smith, William Stanley, Guy Wade.

Coments are closed

Most Popular Posts

  • Speed Download For Mac Crack
  • Shortcut For Mac Force Quit
  • Downloadhelper For Firefox Mac
  • Autorun Inf For Mac

Scroll to top