Dee Evans Deekor

Purging the cache fixed it.

Install the Heroku Repo plugin:

https://github.com/heroku/heroku-repo

Then run:

heroku repo:gc --app your-app-name

You need to configure a PrivateLink. In your databse settings under Heroku Postgres via PrivateLink you can generate a private link to the vpc your AWS glue is running on. Once the link is established youll get some credentials you can use for your JDBC connection in Glue:

Heroku will give you a endpoint url once the private link is established in this format:

psql://username:password@host:5432/databasename you can parse out the username and password and then your jdbc url will be jdbc:postgresql://host:5432/databasename

If you are having an issue, make sure the aws role you are running the connection test through is configured in the heroku privatelink Allowed AWS Account IDs

1. Make sure your command line tools are up to date!

If your logs look something like this error: use of undeclared identifier 'RUBY_FUNCTION_NAME_STRING', command line tools are out of date.

2. Install with the openssl path

Now if your command line tools are up to date and you are getting an error like this:

./openssl_missing.h:195:11: warning: 'TS_VERIFY_CTS_set_certs' macro redefined [-Wmacro-redefined]

Run the install pointing to your brew installation of openssl:

	class MyResource
	include HTTParty
	debug_output $stdout # <= will spit out all request details to the console

	#...
	end

	# Or per request
	response = HTTParty.post(url, :body => body, :debug_output => $stdout)

	ruby:
	Simple rvm install

	yarn:
	https://linuxize.com/post/how-to-install-yarn-on-centos-7/

	postgres:
	https://medium.com/@floodfx/setting-up-postgres-on-cloud9-ide-720e5b879154
	I ended up using `postgres` user instead of `ec2-user` ^
	ident error: https://stackoverflow.com/a/7526119/1094339

	#!/usr/bin/env ruby

	# List all keys stored in memcache.
	# Credit to Graham King at http://www.darkcoding.net/software/memcached-list-all-keys/ for the original article on how to get the data from memcache in the first place.

	require 'net/telnet'

	headings = %w(id expires bytes cache_key)
	rows = []