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).
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:
After downloading iODBC, double-click on the downloaded .dmg file.
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 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:
After downloading ODBC Manager, double-click on the downloaded .dmg file.
Double-click on the installer file,
ODBCManager.pkg, and follow the prompts.
The installer installs ODBC Manager in the
To install the Snowflake ODBC driver for macOS:
If you haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver.
Double-click on the downloaded .dmg file,
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:
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:
To create a DSN, either use ODBC Manager or edit the appropriate
To create a DSN in ODBC Manager:
Start ODBC Manager.
Click on User DSN or System DSN.
Click the Add button.
Select the driver to use (Snowflake) and click OK.
Enter the name of the DSN and optionally a description.
Create a Keyword/Value pair for each DSN parameter:
Click Add to create a Keyword/Value pair.
Select Keyword and replace it with the parameter name.
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.
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
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
Directory path and name of the driver file, in the form of
Connection parameters, such as
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
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:
testodbc2 have default roles.
testodbc2 also has a default database and warehouse.
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
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.
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.
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.
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:
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.
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.
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.
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.
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.
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:
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 are some of the key things you get in Snowflake Pro:
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 …
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:
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.
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.
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.
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!
Here are some online places you can buy How to Write a Novel Using the Snowflake Method:
To go to the download page for Snowflake Pro, click the button below:
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.